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.

Best Regards
Hans

====================================================================

Hundri Magusin wrote:

>
> I'm trying to invoke a filter on a TIBOTable. The filter query in question
> is a compound statement somewhat similar to this:
>
> aTable.Filter:=(x > Quantity_from_Supplier1+Quantity_from_Supplier2);
>
> When I try to do this, I get a "missing or extra" parenthesis. In SQL I know
> I can add this to the where clause and get the correct results so I'm left
> wondering if this is an ibo bug :-(
>
> Any suggestions anyone?
>
>
> ___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
> ___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info papers,
> keyword-searchable FAQ, community code contributions and more !
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/