Read a Record with TQuery and SQL 1

[luistsousa]

Hi

How can I read a record in a mysql table using a Query1.SQL state?

Regards

 

[VeraA]

example:

query1.SQL.Clear;
query1.SQL.Add('Select employee_code from employee_table');
query1.SQL.open;

while not(query1.eof) do
begin
{this is data which you read from the table}
--> query1.fieldbyname('employee_code').asstring;
end;

Hopefully my example can help you

 

[luistsousa]

Yes. Help me a lot.

Thanks