table.First; for i:=0 to table.count do table.fields[n].value=nil;
首先将Query1的RequestLive设为True; with Query1 do begin sql.clear; sql.add('select * from TableName'); open; first; end; for i:=0 to Query1.RecordCount-1 do begin Query1.Edit; Query1.FieldByName('AAA').asstring:='' Query1.post; Query1.next; end;
不要用循环,如果记录有几十万条或几亿条怎么处理的了??用SQL命令,如列名为AAA,则执行SQL命令: update tablename set AAA = '' 类似这样的就可以了。
不用做循环,只要调用update就可以 Update tablename1 set Field1 =''
Update tablename1 set Field ='' 不过问一下你要置‘’还是NULL 我想就这样了
for i:=0 to table.count do
table.fields[n].value=nil;
with Query1 do
begin
sql.clear;
sql.add('select * from TableName');
open;
first;
end;
for i:=0 to Query1.RecordCount-1 do
begin
Query1.Edit;
Query1.FieldByName('AAA').asstring:=''
Query1.post;
Query1.next;
end;
类似这样的就可以了。
Update tablename1 set Field1 =''
不过问一下你要置‘’还是NULL
我想就这样了