www.webdeveloper.com
Results 1 to 2 of 2

Thread: Field Type

  1. #1
    Join Date
    Oct 2003
    Posts
    32

    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
    Location
    London, United Kingdom
    Posts
    117
    Here's a list of the ADO record object's field type properties:

    http://www.devguru.com/Technologies/...eter_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
    You end up being who you are.
    http://www.geocities.com/lillamarta

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



Recent Articles