Missing operator or semicolon
procedure TForm1.Button1Click(Sender: TObject);
begin
Aqu.Close;
Aqu.SQL.Add('select id,v_Name from tb_Test where i_State=0 order by id');
Aqu.Open;
while not Aqu.Eof do
begin
Memo1.Lines.Insert(0,InttoStr(Aqu.Fields(0))+'----'+Aqu.Fields(1));
Comm.Parameters.Clear;
Comm.CommandText:='Insert into tb_Test(v_Name) values (:@v_Name);';
Comm.Parameters.Refresh;
Comm.Parameters[0].value:= datetimetostr(now);
Comm.Prepared:=true;
try
Comm.Execute;
except
memo1.Text:=Comm.CommandText;
end;
Comm.Connection.Close;
Aqu.Next;
end;
end;