Firbird 5.0 / Substring in IbcQuery.Filter
Hello devart team,
Try to filter an IbcQuery (latest release) with firebird 5.0 :
IbQuery1.Filtered :=False;
IbQuery1.Filter := Substring( MyField from 1 for 5) = 'Hello'
IbQuery1.Filtered :=True;
This rise an error : "Substring is an unknown Field"
(Something like this).
With Delphi ClientDataset that was worked fine !
Thx