Subject RE: [IBO] SQLWhereItems->Add - Problem
Author Helen Borrie
At 08:04 AM 13/10/2004 +1000, you wrote:

>Hi Helen,
>
>Thank you for your help.
>
>I made the change you suggested so that the code looks like:
>
> if( !FPrivateRecords )
> crsCVDBCursor->SQLWhereItems->Add("OR (R_SHARED = 1)");
>
>However, I am still having the same problem, The parser is still placing an
>(AND) before the (OR), as you can see from the IB_Monitor output below:
>
>SELECT *
>FROM
>LOGPAS
>WHERE (
>
>R_CREATED_BY =?/*CURRENT_USER*/
> )
>AND OR(R_SHARED = 1)
>FOR UPDATE
>
>Is there any other area in which I could have messed up which I should be
>looking into?

You might have found a bug. Could you let us know what version of IBO you
are using? If I have the same version here, I can look at it in about an hour.

Helen