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.GetLookupTable Method (Typed)

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

Namespace:  XSharp.VO.SDK
Assembly:  XSharp.VOSQLClasses (in XSharp.VOSQLClasses.dll) Version: 2.21
Syntax
Copy
 VIRTUAL METHOD GetLookupTable(
	nMaxRows,
	uField1,
	uField2,
	uSearch
) AS ARRAY 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
uSearch (Optional)
Type: Usual

Return Value

Type: Array
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