Adotable.LookUp Function Question

Please discuss general Delphi programming topics here.

Adotable.LookUp Function Question

Postby sepehr » February 13th, 2007, 3:11 pm

i want to know 2 things about LookUp command of Adotable
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
User avatar
sepehr
Active Member
Active Member
 
Posts: 23
Joined: October 4th, 2006, 6:38 am
Location: Karaj

Postby Kambiz » February 13th, 2007, 7:02 pm

What you looking for is TADOQuery. ;)
Kambiz
User avatar
Kambiz
Administrator
Administrator
 
Posts: 2429
Joined: March 7th, 2003, 7:10 pm


Return to Delphi Programming

Who is online

Users browsing this forum: No registered users and 2 guests

cron