Adoconnection.LookUp Multi Search Parameters

[b][red]This message was edited by sad.boy at 2007-1-26 7:42:57[/red][/b][hr]
i've a MS Access database with following fileds:
ID
name
phone
email
picture
ps:I've Done All Task TO Connect To My DataBase
now i did following code and it works fine ,it gives me
the phone and ID of the person that matches
[code]
procedure TForm1.Button1Click(Sender: TObject);
var
varres:variant;
begin
adotable1.Open;
varres:=adotable1.Lookup('Name','Sepehr','phone;ID');
end;
[/code]

then i did following code,i wanted to search for people that
have the name AND the email that matches
[code]
procedure TForm1.Button1Click(Sender: TObject);
var
varres:variant;
begin
adotable1.Open;
varres:=adotable1.Lookup('Name;email','Sepehr;webmaster@smd.com','phone;ID');
end;
[/code]
now i want to know if this is correct(if not PLEASE tell me the correct
syntax with an example),if i am correct then how varres array is now
accesed?like a multi dimensional array?


Thanks In Advanced


Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories