Retrieving field data types

Results 1 to 2 of 2

Thread: Retrieving field data types

  1. #1
    Sam Critchley Guest

    Default Retrieving field data types

    I need to be able to retrieve the data type of a given field.<BR>I&#039ve tried rs(x).type but that only returns numbers. ie, text = 202.<BR>I havent been able to find any info to translate these numbers and i was kind of hoping that theres a different method of getting this information as translating numbers is real messy.

  2. #2
    Steve Nicholls Guest

    Default Type is a DataTypeEnum value

    The number returned is a DataTypeEnum value.<BR><BR>These are defined in the include file (adVarWChar=202)<BR><BR>I don&#039t think there is another (reliable) way to determine the field type - I suspect using the IsDate, IsnNumeric etc functions would not provide a sufficiently robust solution.<BR><BR>regards, Steve<BR><BR>

Posting Permissions

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