473,320 Members | 2,189 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

what is the yes/no type to be defined in code

syedshaffee
Hey,People
I have a code for checking Type of data that is been uploaded from excel to my database.
Expand|Select|Wrap|Line Numbers
  1. Private Function GetDBDataTypePrefix(ByVal fldDBData As Variant) As String
  2.     Select Case fldDBData.Type
  3.         Case dbDate, dbTime, dbTimeStamp        ', adDate, adDBDate, adDBTime, adDBTimeStamp
  4.             GetDBDataTypePrefix = g_sDBDateChr
  5.         Case dbChar, dbText, dbMemo             ', adWChar, adVarWChar, adVarChar, adLongVarWChar, adLongVarChar, adBSTR
  6.             GetDBDataTypePrefix = "'"
  7.     End Select
  8. End Function
Here is the code for checking which Type of data is been uploaded in my Table so now i want to known the type of yes/no.Eg dbyes/no or adYes/no

Please help
Oct 4 '12 #1
2 1418
zmbd
5,501 Expert Mod 4TB
yes/no table fields are boolean... thus, should be dbboolean
http://allenbrowne.com/ser-49.html
Oct 4 '12 #2
Thanks zmbd thanx a lot
Oct 4 '12 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

354
by: Montrose... | last post by:
After working in c# for a year, the only conclusion I can come to is that I wish I knew c. All I need is Linux, the gnu c compiler and I can do anything. Web services are just open sockets...
5
by: Eric Lilja | last post by:
Using a macro, can I change what type an object is being cast to? I know, the initial respone to question might be an instinctive "ugly, don't even think about it!" or "don't use macros at all",...
3
by: Brett | last post by:
What is the following code doing? I see evt and event but what is the difference? <input type="radio" id="us_countryFlag1" name="us_country" onclick="togglePurDec(event)">Yes <script>...
15
by: damian birchler | last post by:
Hi I'm wondering of what type a structure is. Of course, it is a _structure_, but an array isn't an _array_ either. So of what type is a structure? I'd say a pointer, am I right?
15
by: Leandro Ardissone | last post by:
Hi, I want to know what type is a variable. For example, I get the contents of an xml but some content is a list or a string, and I need to know what type it is. Thanks
5
by: garyusenet | last post by:
Console.WriteLine("Current OS: {0} ", Environment.OSVersion) I'm trying to find out what .OSVersion is. It returns an object which details the OS. I know it's not a method, because it doesnt...
2
exoskeleton
by: exoskeleton | last post by:
hi guys...may i know what type of programming language is this? is this coldfusion? {IF PAGES} {INCLUDE paging} {/IF} {LOOP MESSAGES} {IF NOT MESSAGES->parent_id 0}
7
by: Bill Davy | last post by:
I want to be able to write (const char*)v where v is an item of type Class::ToolTypeT where ToolTypeT is an enumeration and I've tried everything that looks sensible. There's an ugly solution, but...
6
by: fractalengine | last post by:
I have been trying to reverse engineer a small hardware scanning device. The vendor has a DLL with a function called "GetImageData" that I've been executing in VB.NET It is defined as below: ...
6
by: p4willi | last post by:
I've defined two arrays in a Module called PubVars Public Type LinesRec CORRECT As Integer QUESTION As String PROC As Integer PAY As Integer End Type Public Lines_Array() As...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.