> 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@...

tried that - you get a syntax error at OR and the monitor shows it parsed as
"AND OR" on that item
as I say - they help file says if you add a single OR it will not use AND
but use the OR but it doesn't - it sticks an AND in anyway.

Alan