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

Topic Participants