Adoconnection.LookUp Multi Search Parameters - Programmers Heaven

Howdy, Stranger!

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

Categories

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;[email protected]','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.