1.lookup only turns back one record at a time ,is there a way to retrive more than one matching record at a time with SINGLE lookup command?
2.i want to to include more than one search parameter but i can't manage to for example there is a table with following tables:
"Names" "Task" "Email" i want to get name of person that has name 'Neo' and task 'Actor' if it is found bring me the email
that's what i tried but doesn't seem to work
- Code: Select all
var
varres
begin
varres:=adotable1.Lookup('Names;Task','Neo;Actor';'Email');
end;
please give me some example too ,Thanks In Advance