LookupTable Procedure
Opens the lookup page for the given table.
The FieldValue will return the value of the field specified by FieldNo.
Overloads
| Name | Description |
|---|---|
| LookupTable(Variant; Integer; Text): Boolean | Opens the lookup page for the given table. |
| LookupTable(Variant; Text): Boolean | Opens the lookup page for the given table. |
LookupTable(Variant; Integer; Text) Procedure
Opens the lookup page for the given table.
The FieldValue will return the value of the field specified by FieldNo.
Signature
LookupTable(RecRelatedVariant: Variant; FieldNo: Integer; var FieldValue: Text) : Boolean
Parameters
RecRelatedVariant Variant
A record related variant that is the source table for the lookup page.
This parameter can be a Record, RecordRef, RecordID or a Table Number.
FieldNo Integer
The number of the field that will be returned in FieldValue.
If this parameter is 0, the first field of the primary key will be used.
var FieldValue Text
The previous value (if any) of the field to lookup. This field should be XML formatted (Use
Format(value, 0, 9)) if the field has any other data type then text.
The value from the field specified by FieldNo will be returned.
If this parameter has an input value, this will be used to try to position the selected record when the page list is opened.
Returns
Boolean
Returns true if the user has selected a value. Returns false in all other scenarios,
as if the user cancels the lookup, there are no lookup page for the record, RecRelatedVariant is
not a Record related data type (Record, RecordRef, RecordID) or a Table Number.
LookupTable(Variant; Text) Procedure
Opens the lookup page for the given table.
The FieldValue will return the value of the first field of the primary key of the given table.
Signature
LookupTable(RecRelatedVariant: Variant; var FieldValue: Text) : Boolean
Parameters
RecRelatedVariant Variant
A record related variant that is the source table for the lookup page.
This parameter can be a Record, RecordRef, RecordID or a Table Number.
var FieldValue Text
The previous value (if any) of the field to lookup. This field should be XML formatted (Use
Format(value,0,9)) if the field has any other data type then text.
The value from the first field of the primary key of the provided table will be returned.
If this parameter has an input value, this will be used to try to position the selected record when the page list is opened.
Returns
Boolean
Returns true if the user has selected a value. Returns false in all other scenarios,
as if the user cancels the lookup, there are no lookup page for the record, RecRelatedVariant is
not a Record related data type (Record, RecordRef, RecordID) or a Table Number.
This documentation is generated from Smart Toolbox v27.0