Howdy, Stranger!

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

Categories

Welcome to the new platform of Programmer's Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use its exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.

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.