Subject Re: [IBO] ibotable filter problem
Author Costas Droussiotis
hans@... wrote:
> If I remember right, you have to prefix the filter
> with the word 'SQL ', thus
> 'SQL aTable.Filter:=(x > antity_from_Supplier1+Quantity_from_Supplier2)'
> I do know you have to prefix it, but not sure about 'SQL'. Maybe
> menyioned in Docs somewhere.

If I remember correctly it is prefixed like this

This by the way tells the parser that the filter is to be sent to the
server as part of the WHERE clause and not to be performed client-side.
That's probably why the brackets and the prepended 'AND' by the parser
as mentioned elsewhere in the thread.

Costas Droussiotis