with query1 do
close;
sql.clear;
sql.add('select * from aa where bb='''ee''');
open;
first;
while not eof do
begin
需要的东西;
next;
end;满足bb='ee'的记录没有,这段程序有错么,怎么改
close;
sql.clear;
sql.add('select * from aa where bb='''ee''');
open;
first;
while not eof do
begin
需要的东西;
next;
end;满足bb='ee'的记录没有,这段程序有错么,怎么改
sql.add('select * from aa where bb='''ee''');
^
sql.add('select * from aa where bb=''ee''');
begin
close;
sql.clear;
sql.add('select * from aa where bb='''ee''');
open;
if not IsEmpty then //不为空;
begin
first;
while not eof do
begin
需要的东西;
next;
end;
end;
end;
或者
SQL.ADD('SELECT * FROM AA WHERE BB='+'"'+'EE'+'"');
sql.add('select * from aa where bb='''ee''');
^
sql.add('select * from aa where bb= ''ee'' ');
( 'ee' )
i think now you get it.
eof 或者bof有一个是“真”,或者当前的记录已经被删除,所须的操作要求一个当前的记录