Subject Re: [IBO] ibotable filter problem
Author Helen Borrie (TeamIBO)
At 01:08 PM 25-02-02 +0100, you 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?

Yes -
1. observe in the IB_Monitor what the statement is (you cannot live for
long in client/server without IB_Monitor). That might help to get you
familiar with what the parser is doing with the elements of the statement.

2. Amend the filter clause so that the brackets actually do something
useful (like isolating the evaluation expression):

aTable.Filter:= x > (Quantity_from_Supplier1+Quantity_from_Supplier2);

If brackets are not logically necessary, don't add them. The parser itself
will add extra brackets if it needs them. Just for interest's sake, you
could try including a pair of redundant brackets right around the corrected
Filter string and test whether the parser will bounce it:

aTable.Filter:= (x > (Quantity_from_Supplier1+Quantity_from_Supplier2));

Helen Borrie (TeamIBO Support)

** Please don't email your support questions privately **
Ask on the list and everyone benefits
Don't forget the IB Objects online FAQ - link from any page at