SQLValue.UsualType Property | |
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
public virtual Usual UsualType { get; }
Request Example
View SourceProperty Value
Type:
UsualA 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 Type | VO Type |
---|
SQL_INTEGER | LONG |
SQL_SMALLINT | SHORTINT |
SQL_FLOAT | FLOAT |
SQL_REAL | FLOAT |
SQL_DOUBLE | FLOAT |
SQL_BIT | LOGIC |
SQL_DATE | DATE |
All other values | STRING |
Tip |
---|
Refer to your ODBC documentation for a complete list of ODBC usual types that are available for that particular driver. |
See Also