Field Type

[fark]

I wanted to get the type of a field in my database so I tried this objCleanUpRS.Fields(I).Type and got this:

3 Number
6 Currency
7 Date/Time
202 Text

with my guess of the translation next to it.

Is this correct?
Does anyone know what the rest of the codes are???
Thanks (Once Again)

[lillu]

Here's a list of the ADO record object's field type properties:

http://www.devguru.com/Technologies/ado/quickref/parameter_type.html

Your guesses were right...

adInteger 3 4-byte signed integer
adCurrency 6 Currency format
adDate 7 Number of days since 12/30/1899
adVarWChar 202 Null-terminated Unicode character string