[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: dynamic where clauses

Just to add my .02

I use the following style when I know my dynamic where will include ANDs

if $where_flag = 'Y'
     $dyna_where =     ' Your conditions here'
else
     $dyna_where = '1=1'
end-if

later...

begin-select
>From DB
Where [$dyna_where]
AND    !  'other where conditions'
end-select


David L Smith
IBM Global Services