Click or drag to resize

SQLSelect.FieldInfo Method

X#
Retrieve information about or set an alias for the indicated column.

Namespace:  VO
Assembly:  VOSQLClasses (in VOSQLClasses.dll) Version: 2.21
Syntax
 VIRTUAL METHOD FieldInfo(
	kFieldInfoType,
	uFieldPos,
	uFieldVal
) AS USUAL CLIPPER
Request Example View Source

Parameters

kFieldInfoType (Optional)
Type: Usual
The type of information, as specified by the following constants:
uFieldPos (Optional)
Type: Usual
The name, number, or symbol representing the desired column.
uFieldVal (Optional)
Type: Usual
The alias name to be assigned to the column. This argument is only used if DB_ALIAS is specified for kColumnInfoType.

Return Value

Type: Usual
A value (whose data type depends on the value requested) if successful; otherwise, NIL.
Remarks
ConstantDescription
DBS_ALIASAlternate name (or alias) by which a column can be referenced
DBS_DECNumber of decimal places
DBS_LENLength (field size) as a number
DBS_NAMEField name as a string
DBS_TYPEData type as a string
The SQLSelect:FieldInfo() method is used to retrieve information about a column, except if you specify kColumnInfoType to be DBS_ALIAS. You can then specify an alias for a column, which you can access by using the SQLColumn:AliasName property.
See Also