With ADOQuery1, SQL do
begin
Close;
Clear;
Add('INSERT INTO archivetitles ');
Add('(title_id, title, type, pub_id)');
Add('SELECT title_id, title, type, pub_id');
Add('FROM titles');
Add('WHERE (pub_id = '0766')');
Open;
end;提示错误
ADOQuery1 commandText does not return a redult set'.Process stopped.Use Step or Run to continue请问应该怎么写?
begin
Close;
Clear;
Add('INSERT INTO archivetitles ');
Add('(title_id, title, type, pub_id)');
Add('SELECT title_id, title, type, pub_id');
Add('FROM titles');
Add('WHERE (pub_id = '0766')');
Open;
end;提示错误
ADOQuery1 commandText does not return a redult set'.Process stopped.Use Step or Run to continue请问应该怎么写?
open 改为 execsql
删除,插入用execsql
这个东西要调用两次的 一次是ExecSQL 令一次应该是 open