i´ve a problem with the TMyQuery.FilterSQL between MyDac 3.30 and 4.00.
Example:
Code: Select all
procedure TForm1.Button1Click(Sender: TObject);
begin
MyQuery1.Close;
MyQuery1.SQL.Text:='select AZ1, AZ2, AZ3, Land from adress WHERE Land=''GB'' ORDER BY AZ1';
MyQuery1.open;
end;
procedure TForm1.Button2Click(Sender: TObject);
begin
MyQuery1.FilterSQL:='AZ1 like ''%bank%''';
end;
At Button2-Click in 4.00 comes an SQL-Error with the following SQL-Code
Code: Select all
select AZ1, AZ2, AZ3, Land
from adress
WHERE AZ1 like '%bank%'
WHERE Land='GB'
ORDER BY AZ1
Did you have a solution for the problem?
Best regards
Harald