adoquery.close; adoquery.sql.clear; adoquery.sql.add('select * from table'); adoquery.open; for i:=0 to 30 do begin adoquery.append; adoquery.fieldbyname('列名').asstring:=....;//这边是需要添加的数据 ....// adoquery.post; end;
sql2000 ADOQuery1.recno 作为控制记录顺序,插入操作该怎么修改呢
select * from table order by recnoupdate table set recno=recno+1 where recno>:insertrecnoinsert into table values(.....)
adoquery.sql.clear;
adoquery.sql.add('select * from table');
adoquery.open;
for i:=0 to 30 do
begin
adoquery.append;
adoquery.fieldbyname('列名').asstring:=....;//这边是需要添加的数据
....//
adoquery.post;
end;
ADOQuery1.recno 作为控制记录顺序,插入操作该怎么修改呢
select * from table order by recnoupdate table set recno=recno+1 where recno>:insertrecnoinsert into table values(.....)