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
SQL::Filter_expression

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.


Rgds,
Costas Droussiotis