SQLSelect.FIELDGET Method | |
Retrieve the contents of the specified column.
Namespace:
VO
Assembly:
VOSQLClasses (in VOSQLClasses.dll) Version: 2.19
Syntax VIRTUAL METHOD FIELDGET(
uField
) AS USUAL CLIPPER
[ClipperCallingConventionAttribute(new string[] { ... })]
public override Usual FIELDGET(
Usual uField = default
)
Request Example
View SourceParameters
- uField (Optional)
- Type: Usual
The name, number, or symbol representing the desired column.
Return Value
Type:
Usual
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:
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