Locate Lookup.
function Locate(const KeyFields: string; const KeyValues: Variant; Options; TLocateOptions): Boolean;
function Lookup(const KeyFields: string; const KeyValues: Variant; const ResultFields: string): Variant;
Locate , ( KeyFields, ), ( KeyValues, ) ( options). loCaseinsensitive, , loPartiaiKey, . Locate True - .
, . , EditName. .
QueryPerson.Locate('PR_NAME', 'EditName.Text', [loPartialKey, loCaseInsensitive])
, EditName2
QueryPerson.Locate('PR_NAME;PR_NAME2', VarArrayOf([EditName.Text, EditName2.Text]), [loPartialKey, loCaseInsensitive])
VarArrayOf, Variant.
Lookup , . Lookup , , , . , Lookup (Null) .
LookupRes. ('PR_NAME;PR_NAME2'), EditName EditName2 , LookupRes ('PR_NAME3;PR_BIRTHDAY').
var LookupRes: Variant;
LookupRes:= QueryPerson.Lookup('PR_NAME;PR_NAME2', VarArrayOf([EditName.Text, EditName2.Text]), 'PR_NAME3;PR_BIRTHDAY');
If not VarIsNull(LookupRes) then
ShowMessage(VarToStr(LookupRes[0])) //
VarIsNull , , , .
VarToStr .
property RecNo: Integer;
property RecordSize: Word;
. , . .
|
|
property Fields: TFields;
property FieldDefs: TFieldDefs;
property FieldCount: Integer;
BLOB
property BlobFieldCount: Integer;
property FieldValues[const FieldName: string]: Variant; default;
FieldName .
. , :
for i:= 0 to MyTable.FieldCount - 1 do
MyTable.Fields[i].DiplayFormat:= '#.###';
, ,
function FieldByName(const FieldName: string): TField;
:
MyTable.FieldByName('VENDORNO').Aslnteger:= 1234;
, FieldName, .
procedure GetFieldNames(List: TStrings);
List .
.