query1.sql.clear; query1.sql.add('select table_id from table_name '); if not query1.prepared then query1.prepare querry1.open; if not query1.IsEmpty then Edit1.Text:=query1.FieldByName('table_id').AsStrin; query1.close;
with query1 do begin close; sql.clear; sql.text := 'select * from tablename where ..'; open; edit1.text := fieldbyname('fieldname').asstring; end;
query1.sql.clear;
query1.sql.add('select table_id from table_name ');
if not query1.prepared then query1.prepare
querry1.open;
if not query1.IsEmpty then
Edit1.Text:=query1.FieldByName('table_id').AsStrin;
query1.close;
begin
close;
sql.clear;
sql.text := 'select * from tablename where ..';
open;
edit1.text := fieldbyname('fieldname').asstring;
end;