Click or drag to resize

SQLValue.UsualType Property

X#
A string representing the X# usual type corresponding to the originating ODBC type (for example, SQL_INTEGER returns LONG).

Namespace:  VO
Assembly:  VOSQLClasses (in VOSQLClasses.dll) Version: 2.19
Syntax
 VIRTUAL PROPERTY UsualType AS USUAL GET 
Request Example View Source

Property Value

Type: Usual
A string representing the X# usual type corresponding to the originating ODBC type (for example, SQL_INTEGER returns LONG).
Remarks
A string representing the X# usual type corresponding to the originating ODBC type (for example, SQL_INTEGER returns LONG).

Possible ODBC types and their return values include:

ODBC TypeVO Type
SQL_INTEGERLONG
SQL_SMALLINTSHORTINT
SQL_FLOATFLOAT
SQL_REALFLOAT
SQL_DOUBLEFLOAT
SQL_BITLOGIC
SQL_DATEDATE
All other valuesSTRING
Tip Tip
Refer to your ODBC documentation for a complete list of ODBC usual types that are available for that particular driver.
See Also