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

SQLSelect.GetLookupTable Method

X#
Retrieve a two-column array of values from two fields in the server.

Namespace:  VO
Assembly:  VOSQLClasses (in VOSQLClasses.dll) Version: 2.19
Syntax
Copy
 VIRTUAL METHOD GetLookupTable(
	nMaxRows,
	uField1,
	uField2
) AS USUAL CLIPPER
Request Example View Source

Parameters

nMaxRows (Optional)
Type: Usual
The maximum number of rows that should be retrieved. If omitted, the default is 100. The name, number, or symbol of the first field to be retrieved. If omitted, the first field is retrieved. The name, number, or symbol of the second field to be retrieved. If omitted, the second field is retrieved.
uField1 (Optional)
Type: Usual
uField2 (Optional)
Type: Usual

Return Value

Type: Usual
The method returns a two-column array of values found for the specified fields, moving sequentially until the specified maximum number of rows or until end of file. Note that the method does not reposition to the beginning before starting to fill the array. Either provide a start value, or explicitly position the server before using the method. (This allows incremental reading, building up an array in pieces.)
Remarks
Sends a NotifyRecordChange message afterwards, and leaves the server positioned at the last record used or at end of file (last file record). One use of this method is to populate translation lists in user interfacing. The resulting array can be used in ATranslate().
Examples
The following builds a lookup table, for example to translate product codes into product names and vice versa, beginning at the indicated product number:
X#
Copy
1oSQLSelect := SQLSelect{"SELECT * FROM products WHERE ProdNo > 100"}
2aProducts := SQLSelect:GetLookupTable(500,#ProdNo, #ProdName)
3oSQLSelect:Close()
See Also