X# Runtime and VO SDK Reference
X# Runtime and SDK Reference
XSharp.VO.SDK Namespace
SQLSelect Class (Typed)
SQLSelect Methods (Typed)
SQLSelect.AddDateVal Method (Typed)
SQLSelect.AddTimeString Method (Typed)
SQLSelect.Append Method (Typed)
SQLSelect.AppendRow Method (Typed)
SQLSelect.BindColumn Method (Typed)
SQLSelect.Close Method (Typed)
SQLSelect.Column Method (Typed)
SQLSelect.ColumnAttributes Method (Typed)
SQLSelect.Commit Method (Typed)
SQLSelect.DataField Method (Typed)
SQLSelect.Delete Method (Typed)
SQLSelect.DirectSkip Method (Typed)
SQLSelect.Error Method (Typed)
SQLSelect.Execute Method (Typed)
SQLSelect.ExtendedFetch Method (Typed)
SQLSelect.Fetch Method (Typed)
SQLSelect.FieldGet Method (Typed)
SQLSelect.FieldGetFormatted Method (Typed)
SQLSelect.FieldHyperLabel Method (Typed)
SQLSelect.FieldInfo Method (Typed)
SQLSelect.FieldName Method (Typed)
SQLSelect.FieldPos Method (Typed)
SQLSelect.FieldPut Method (Typed)
SQLSelect.FieldSpec Method (Typed)
SQLSelect.FieldStatus Method (Typed)
SQLSelect.FieldSym Method (Typed)
SQLSelect.FieldValidate Method (Typed)
SQLSelect.FindTableName Method (Typed)
SQLSelect.FLock Method (Typed)
SQLSelect.FreeStmt Method (Typed)
SQLSelect.GetData Method (Typed)
SQLSelect.GetdateVal Method (Typed)
SQLSelect.GetLookupTable Method (Typed)
SQLSelect.GetStatementOption Method (Typed)
SQLSelect.GetTimeStamp Method (Typed)
SQLSelect.GetTimeString Method (Typed)
SQLSelect.GoBottom Method (Typed)
SQLSelect.GoTo Method (Typed)
SQLSelect.GoTop Method (Typed)
SQLSelect.NoIVarGet Method (Typed)
SQLSelect.NoIVarPut Method (Typed)
SQLSelect.Notify Method (Typed)
SQLSelect.NumResultCols Method (Typed)
SQLSelect.PreExecute Method (Typed)
SQLSelect.Prepare Method (Typed)
SQLSelect.Refresh Method (Typed)
SQLSelect.RejectChanges Method (Typed)
SQLSelect.Requery Method (Typed)
SQLSelect.ReReadRow Method (Typed)
SQLSelect.ResetCursor Method (Typed)
SQLSelect.ResetNotification Method (Typed)
SQLSelect.RLock Method (Typed)
SQLSelect.RLockVerify Method (Typed)
SQLSelect.Rollback Method (Typed)
SQLSelect.SetColumnAttributes Method (Typed)
SQLSelect.SetDataField Method (Typed)
SQLSelect.SetPos Method (Typed)
SQLSelect.SetPrimaryKey Method (Typed)
SQLSelect.SetStatementOption Method (Typed)
SQLSelect.SetTimeStamp Method (Typed)
SQLSelect.ShowSQLError Method (Typed)
SQLSelect.Skip Method (Typed)
SQLSelect.SuspendNotification Method (Typed)
SQLSelect.UnLock Method (Typed)
SQLSelect.Update Method
SQLSelect.UpdateCursor Method (Typed)
SQLSelect.UpdateKey Method (Typed)
SQLSelect.UpdateVal Method (Typed)
Click or drag to resize

SQLSelect.FieldInfo Method (Typed)

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

Namespace:  XSharp.VO.SDK
Assembly:  XSharp.VOSQLClasses (in XSharp.VOSQLClasses.dll) Version: 2.21
Syntax
Copy
 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