Subject Re: [IBO] ibotable filter problem
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


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.
> ___________________________________________________________________________
> - your IBO community resource for Tech Info papers,
> keyword-searchable FAQ, community code contributions and more !
> Your use of Yahoo! Groups is subject to