SQLSelect.FIELDGET Method |  |
Retrieve the contents of the specified column.
Namespace: VO
Assembly: VOSQLClasses (in VOSQLClasses.dll) Version: 2.21
SyntaxRequest Example
View Source
The contents of the specified column, whose data type depends on the data type of the column, which is available from the Column() or ColumnAttributes() method. The following table shows how the ODBC database data type is mapped to the X# return value and the return value if the SQL value of the column is NULL:
Parameters
- uField (Optional)
- Type: Usual
The name, number, or symbol representing the desired column.
Return Value
Type: UsualThe contents of the specified column, whose data type depends on the data type of the column, which is available from the Column() or ColumnAttributes() method. The following table shows how the ODBC database data type is mapped to the X# return value and the return value if the SQL value of the column is NULL:
| ODBC Data Type | Return Value - NULL Return Value |
|---|---|
| SQL_BIGINT | DWORD - NIL |
| SQL_BIT | LOGIC - NIL |
| SQL_CHAR | STRING - NULL_STRING |
| SQL_DATE | DATE - NULL_DATE |
| SQL_DECIMAL | REAL8 - NIL |
| SQL_DOUBLE | REAL8 - NIL |
| SQL_FLOAT | REAL8 - NIL |
| SQL_INTEGER | LONGINT - NIL |
| SQL_LONGVARBINARY | MEMO - NULL_STRING |
| SQL_LONGVARCHAR | MEMO - NULL_STRING |
| SQL_NUMERIC | REAL8 - NIL |
| SQL_REAL | REAL4 N- IL |
| SQL_SMALLINT | SHORTINT - NIL |
| SQL_TIME | STRING - NULL_STRING |
| SQL_TIMESTAMP | STRING - NULL_DATE |
| SQL_TINYINT | BYTE - NIL |
| SQL_VARCHAR | STRING - NULL_STRING |
See Also