Hello Alan,

How about this:
IB_QJobsAccounts.SQLWhereItems.Add( '(PROCESSED=''N'') OR (ABORTED=''Y'')');


--
Best regards,
Ramil R. Khabibullin khabibr@...

>
>
>
>
>
> With regard to SQLWhereItems, The help file says:
> "Each unit of entries must aggregate to a syntactically valid SQL expression
> that evaluates to a Boolean True or False. It is possible to include
> parentheses to to provide for nesting of items. By default, all items are
> "ANDed" together, but if the OR operator is placed as an item on its own, it
> will be used instead of the default 'AND'."
>
> But if I do this
> IB_QJobsAccounts.SQLWhereItems.Add('(PROCESSED=''N'')');
> IB_QJobsAccounts.SQLWhereItems.Add('OR');
> IB_QJobsAccounts.SQLWhereItems.Add('(ABORTED=''Y'')');
>
> The SQL Monitor reveals this translation:
>
> WHERE (
> (
> (PROCESSED='N')
> )
> AND OR
> )
> AND (ABORTED='Y')
>
> and of course there is a syntax error here at "AND OR"
>
> Does anyone know what the trick is to make items get parsed the way I think
> the help file intends?
>
> regards
> Alan McDonald
>
>
>
>
>