大家好,我用adoquery把记录放入临时表中,再通过一个 checkbox判断状态,选中了的就删除,下面是我的删除语句
Queryreceivables.DisableControls; with Queryreceivables do
begin
first for i:=1 to RecordCount+1 do
begin
if FieldValues['state']=true then
Delete;
next;
end;
end
Queryreceivables.EnableControls ;FieldValues['state']是checkbox类型的
现在就是我如果最后一跳记录如果没选中的话,执行以上语句就会留下一跳我打钩了的记录没删除
请问大家有什么解决方法
Queryreceivables.DisableControls; with Queryreceivables do
begin
first for i:=1 to RecordCount+1 do
begin
if FieldValues['state']=true then
Delete;
next;
end;
end
Queryreceivables.EnableControls ;FieldValues['state']是checkbox类型的
现在就是我如果最后一跳记录如果没选中的话,执行以上语句就会留下一跳我打钩了的记录没删除
请问大家有什么解决方法
解决方案 »
- count() as 的值如何被取出到内存中供别的地方调用
- 新建一个MDI窗体,怎么能干净点?
- 我有一个硬盘, 扩展分区删除,但是没有Format, 是否能恢复 ?
- ExpressQuantumGrid Suite V5有没有FOR D6的及其补丁,哪有下?
- 关于TdateTimePicker(问题解决送50分)
- 如何打开后缀名为.ppt的文件???
- delphi的前景到底如何?我到底学delphi还是c#?十万火急请教各位兄弟!(我现在用java,jsp,asp,主要写b/s程序,我想充实自己学学c/s编程)
- 关于一个变量的问题
- 关于richedit和memo的问题
- 目录、文件与TreeView的问题。
- 如何把一条很长的数据分块储存到数据库中?个位大侠帮帮忙啊
- 非数字型数据在搜索时如何比较大小
Queryreceivables.DisableControls;
with Queryreceivables do
begin
first while not RecordCount.eof do
begin
if FieldByName('state').AsBoolean = true then
Delete;
next;
end;
end Queryreceivables.EnableControls ;
begin
if FieldByName('state').AsBoolean = true then
Delete
else
next;
end;
end
with Queryreceivables do
begin
first for i:=1 to RecordCount do
begin
if FieldValues['state']=true then
Delete;
end;
next;
end
Queryreceivables.EnableControls ;
BM: TBookStr;//定义变量
try
cds_NWSampleBal_I.First;
while not cds_NWSampleBal_I.Eof do
begin
if cds_NWSampleBal_I.State in [dsEdit,dsInsert] = False then cds_NWSampleBal_I.Edit;
begin
if (cds_NWSampleBal_I.FieldByName('SPOUT_DATE').AsString = '') then
cds_NWSampleBal_I.Delete
else
cds_NWSampleBal_I.Next; end ;
end;
finally
cds_NWSampleBal_I.First;
cds_NWSampleBal_I.Book := BM;
cds_NWSampleBal_I.EnableControls;
end;
Queryreceivables.DisableControls; with Queryreceivables do
begin
first for i:=1 to RecordCount+1 do
begin
if FieldValues['state']=true then
Delete
else
next;
end;
end;
Queryreceivables.EnableControls ;
Queryreceivables.DisableControls;
with Queryreceivables do
begin
first
While not eof do
begin
if FieldValues['state']=true then
Delete
else
next;
end;
end
Queryreceivables.EnableControls ;