Delphi database locating

[Judder]

Ok, i have used the locate procedure to find a value, say staff_id. I then want to another value relating to that staff_id. The only way i can think of describing it is by showing you this picture......

So ive found staff_id and i want staff_level as well.

 

[TealWren]

Locate can find more than one value at a time:

query.locate('staff_id;staff_level',VarArrayOf([id, level]),[]);

Hope that helps
TealWren

 

[Judder]

but i want to adotable1.locate('staff_username',edit1.text,[]) then i want to say that if staff_level> "a value" then "do somthing"

Do i have to use paramaters and use SQL?

 

[svanels]

Using a query in the SQL property key down:

SELECT staff_id, staff_level
FROM STAFF
where staff_username Like :SearchString

In the Onchange event of edit1 key in

begin
Adoquery.close;
ParamByName('SearchString').AsString := edit1.text;
Adoquery.open;
if Adoquery.FieldByName('staff_level').asString = ...
then blabla
end;

Hope this helps S. van Els
SAvanEls@cq-link.sr