Retrieve the data type of a column from the active connection
Usage:
dbFieldAttributes (object me, string tableName, string fieldName)
Parameter:
tableName - (string) the name of the table in the data file. Use getTableNames() to obtain the list of tables available.
fieldName - (string) the name of the column in the data file. Use getTableFieldNames() to obtain the list of column names in a table.
Returns:
list with a single string value - return values can be either of the following:
adBigInt, adBinary, adBoolean, adBSTR, adChapter, adChar, adCurrency, adDate, adDBDate, adDBTime, adDBTimeStamp,
adDecimal, adDouble, adEmpty, adError, adFileTime, adGUID, adIDispatch, adInteger, adIUnknown, adLongVarBinary
adLongVarWChar, adNumeric, adPropVariant, adSingle, adSmallInt, adTinyInt, adUnsignedBigInt, adUnsignedInt,
adUnsignedSmallInt, adUnsignedTinyInt, adUserDefined, adVarBinary, adVarChar, adVariant, adVarNumeric, adVarWChar
adWChar, *UNKNOWN*
Example:
xtRose = xtra("Rosetta").new( )
xtRose.dbOpen( "Provider=MSDASQL;ExtendedAnsiSQL=2;DRIVER={Microsoft Access Driver (*.mdb)};Dbq="&the moviepath&"main" )
myAttribute = xtRose.dbFieldAttributes( "MSysAccessObjects", "ID" )
Notes:
While dbFieldAttributes() can obtain useful field type information, however Director natively do not support most of these data types. When retrieving data, Rosetta automatically converts most data types into strings.