[dba-VB] Re: [AccessD] Getting Field Type From ADO Control

MartyConnelly martyconnelly at shaw.ca
Thu Sep 11 17:40:04 CDT 2003


Here is a list of ADO constants for their field type
http://www.able-consulting.com/ADODataTypeEnum.htm

Stuart McLachlan wrote:

>On 11 Sep 2003 at 21:08, Stuart McLachlan wrote:
>
>  
>
>>Field types are enumerated constants.
>>
>>In your VB project, set a reference to DAO then open the Object 
>>Browser.
>>
>>Open the DAO library and look at Globals.
>>
>>    
>>
>
>Just noticed, you said ADO, not DAO.
>
>ADO Constants have different values.
>
>ie 
>dbBigInt = 16, adBigInt = 20
>dbBinary = 9, adBinary = 128
>dbBoolean = 1, adBoolean = 11
>etc.
>
>You will ned to set the reference to ADO , not DAO to get the correct 
>values
>
>
> 
>  
>


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the dba-VB mailing list