query1.close; query1.sql.clear; query1.sql.add('select * form tablename '); query1.open; if query1.recondcount=0 then showmessage('空表'); 大概就是这样了
query1.close; query1.sql.clear; query1.sql.add('select * form tablename '); query1.open; if query1.recondcount=0 then showmessage('空表'); WHILE NOT QUERY1.EOF DO BEGIN Z1:=QUERY1.FIELD[0].ASFLOAT(ASSTRING); QUERY1.NEXT; END;
query1.close; query1.sql.clear; query1.sql.add('select * form tablename '); query1.open; if query1.IsEmpty then showmessage('空表'); Query1.First; while not Query1.Eof do begin ShowMessage(Query1.FieldByName('MyField').asString); Query1.Next; end;
query1.sql.clear;
query1.sql.add('select * form tablename ');
query1.open;
if query1.recondcount=0 then
showmessage('空表');
大概就是这样了
query1.sql.clear;
query1.sql.add('select * form tablename ');
query1.open;
if query1.recondcount=0 then
showmessage('空表');
WHILE NOT QUERY1.EOF DO
BEGIN
Z1:=QUERY1.FIELD[0].ASFLOAT(ASSTRING);
QUERY1.NEXT;
END;
query1.sql.clear;
query1.sql.add('select * form tablename ');
query1.open;
if query1.IsEmpty then
showmessage('空表');
Query1.First;
while not Query1.Eof do
begin
ShowMessage(Query1.FieldByName('MyField').asString);
Query1.Next;
end;