DeleteWhere BUG
Posted: Thu 26 Jan 2006 09:55
Hi, I’m using SDAC 3.55.2.22.
In my application I’d like to use DeleteWhere function of TMSQuery object, but the result is wrong.
Simple example of code:
Could you help me to solve this problem.
I’m looking forward to your answer.
Thanks.
In my application I’d like to use DeleteWhere function of TMSQuery object, but the result is wrong.
Simple example of code:
Code: Select all
MSQuery1.SQL.Text :=
select * from dbo.sysobjects
where xtype='FN'
Code: Select all
procedure TForm1.Button2Click(Sender: TObject);
begin
ShowMessage(MSQuery1.FinalSQL);
MSQuery1.DeleteWhere;
if MSQuery1.Active then MSQuery1.Refresh
else MSQuery1.Open;
ShowMessage(MSQuery1.FinalSQL);
end;
I’m looking forward to your answer.
Thanks.