Subject | Re: [IBO] ibotable filter problem |
---|---|
Author | Costas Droussiotis |
Post date | 2002-02-25T16:33:17Z |
hans@... wrote:
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
>If I remember correctly it is prefixed like this
> 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.
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