Hello Alan,

Ok, according to the help file it is necessary for you:
SQLWhereItems.Add( '(' );
SQLWhereItems.Add( 'PROCESSED=''N''' );
SQLWhereItems.Add( 'OR' );
SQLWhereItems.Add( 'ABORTED=''Y''' );
SQLWhereItems.Add( ')' );

and when parsed into the finalized SQL statement will end up as:
WHERE .... < original criteria plus other system stuff >
AND ( PROCESSED=''N'' OR ABORTED=''Y'' )

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

>
>
>
>
>
>> Hello Alan,
>>
>> How about this:
>> IB_QJobsAccounts.SQLWhereItems.Add( '(PROCESSED=''N'') OR
>> (ABORTED=''Y'')');
>>
>>
>
> yes - of course, for a simple example but when you need to add several OR
> items, this sort of thing becomes impossible.
> Alan
>
>
>
>
>