-
datatype of table field
hi friends
I what to now the type name of a field of a table
Eg rs.fields("name").type
This returns 10 which means it is a string
is their any fuction or some solution so that i can get the typename of the field
I.e "String" instead of 10
rs.fields("name").type returns interger(1,10,8) i want the typename such as "boolean","string","date"
-
Use the TypeName function on the Value property. I am not sure if this will work in all cases. For example, the database field might be defined as a String but contain Date values. TypeName may return Date and not the expected String. Just test to make sure.
TypeName(rs.fields("name").Value)
-
sorry to say but ur option does not work !!