Results 1 to 2 of 2

Thread: Field Type

  1. #1
    Join Date
    Oct 2003

    Field Type

    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)

  2. #2
    Join Date
    Aug 2003
    London, United Kingdom
    Here's a list of the ADO record object's field type properties:


    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
    You end up being who you are.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
HTML5 Development Center