DeleteWhere BUG

[Lisichkin]

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:

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;

Could you help me to solve this problem.
I’m looking forward to your answer.

Thanks.

[Ikar]

Thank you for information.
We reproduced your problem and fixed it. This fix will be included in the next SDAC build. It will be available in about two days.
Please look forward for announcements at the forum.