求解一个adoquery的语句,我初学不懂,大家教教我。
procedure TForm1.Timer1Timer(Sender: TObject);
begin
with ADQ do
begin
sql.Clear;
sql.Add('select Mobile,Big_Number,ServiceCode from xb_command_send where state=1');
open;
if ADQ .RecordCount>0 then
begin
Smobile:=adq.FieldValues['Mobile'] ;
Sbig_number:=adq.FieldValues['Big_Number'];
SServiceCode:=adq.FieldValues['ServiceCode'];
sql.Clear;
sql.Add('update XB_Command_Send state=0 where mobile='''+SMobile+'''');
ADQ .ExecSQL;
end
else
sql.Clear;
end;
end;
在时钟下有这么一个过程,但是这样肯定不好的,我想用
temsql='select Mobile,Big_Number,ServiceCode from xb_command_send where state=1'
adq......(不懂怎么写)
while not ... do
begin
next
end
这个怎么用?能不能帮我改改啊,