Reading data type of database field

[michelle]

VB5:

Hi vb progs,

To fill in information in my database I, have to check this information (Number,Text, Memo etc.)
I did try to find it to search in VB5 the property behind the dot
MyDYN(MyField).??????

Is there any property to get this information.

Nice greetings,

Michelle.

[smalig]

Look this sample http://smalig.tripod.com/vb/119906.html

------------------
smalig
smalig@hotmail.com
smalig.tripod.com (http://smalig.tripod.com)

[Serge]

You can check the Type property of that field.


Recordset.Field("MyField").Type

The type would be one of the following constants:


dbBigInt - Big Integer
dbBinary - Binary
dbBoolean - Boolean
dbByte - Byte
dbChar - Char
dbCurrency - Currency
dbDate - Date/Time
dbDecimal - Decimal
dbDouble - Double
dbFloat - Float
dbGUID - GUID
dbInteger - Integer
dbLong - Long
dbLongBinary - Long Binary (OLE Object)
dbMemo - Memo
dbNumeric - Numeric
dbSingle - Single
dbText - Text
dbTime - Time
dbTimeStamp - Time Stamp
dbVarBinary - VarBinary


Regards,

------------------

Serge

Software Developer
Serge_Dymkov@vertexinc.com
Access8484@aol.com
ICQ#: 51055819 (http://www.icq.com/51055819)