ETUser.DisableControls;
try
for i := 0 to wwDBGrid1.SelectedList.Count - 1 do
begin
ETUser.GotoBook(wwDBGrid1.SelectedList[i]);
Userid.Text:=ETUser.FieldByName('Userid').AsString;
pun:='';
pun:=Trim(Userid.Text);
s:='是否删除'+pun+'会员的所有资料';
if messagedlg(s,mtconfirmation,[mbyes,mbno],0)=mryes then begin
if DataSource1.DataSet.IsEmpty<>True then begin
DataSource1.DataSet.Delete;
end;
//删除会员积分
my.ETJifei.SQL.Clear;
my.ETJifei.SQL.Add('delete Ujifei where Userid='''+pun+'''');
my.ETJifei.UpdateBatch();
end;
finally
ETUser.EnableControls;
end;
积分表里有多条同一用户的数据,只能删除一条而且报错是哪问题?我应该怎么写
try
for i := 0 to wwDBGrid1.SelectedList.Count - 1 do
begin
ETUser.GotoBook(wwDBGrid1.SelectedList[i]);
Userid.Text:=ETUser.FieldByName('Userid').AsString;
pun:='';
pun:=Trim(Userid.Text);
s:='是否删除'+pun+'会员的所有资料';
if messagedlg(s,mtconfirmation,[mbyes,mbno],0)=mryes then begin
if DataSource1.DataSet.IsEmpty<>True then begin
DataSource1.DataSet.Delete;
end;
//删除会员积分
my.ETJifei.SQL.Clear;
my.ETJifei.SQL.Add('delete Ujifei where Userid='''+pun+'''');
my.ETJifei.UpdateBatch();
end;
finally
ETUser.EnableControls;
end;
积分表里有多条同一用户的数据,只能删除一条而且报错是哪问题?我应该怎么写
my.ETJifei.SQL.Clear;
my.ETJifei.SQL.Add('delete from Ujifei where Userid='''+pun+'''');
my.ETJifei.ExecSQL;
try
for i := wwDBGrid1.SelectedList.Count - 1 downto 0 do
begin
ETUser.GotoBook(wwDBGrid1.SelectedList[i]);
Userid.Text:=ETUser.FieldByName('Userid').AsString;
pun:='';
pun:=Trim(Userid.Text);
s:='是否删除'+pun+'会员的所有资料';
if messagedlg(s,mtconfirmation,[mbyes,mbno],0)=mryes then
begin
if DataSource1.DataSet.IsEmpty <>True then begin
DataSource1.DataSet.Delete;
end;
//删除会员积分
my.ETJifei.SQL.Clear;
my.ETJifei.SQL.Add('delete Ujifei where Userid='''+pun+'''');
my.ETJifei.execsql
end;
finally
ETUser.EnableControls;
end;