Click or drag to resize

SQLValue.UsualType Property (Typed)

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

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

Property Value

Type: DWord
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