Subject | best way to phrase an or statement |
---|---|
Author | Grant Brown |
Post date | 2005-06-25T11:43:38Z |
Hi all,
Is the following or statement the way to go or is there a better (ie
faster) way in which to obtain the same outcome.
if ((EXISTS(select DT from LETTERS_01 where DT=:FIND_ID))
or (EXISTS(select DT from LETTERS_02 where DT=:FIND_ID))
or (EXISTS(select DT from LETERS_03 where DT=:FIND_ID))) then Delete_OK
= -48;
tia
--
Regards,
Grant Brown
Product Development Manager
Phone : 02 4229 1185
Mobile : 0412 926 995
Email : grant@...
Web : www.sitedoc.com.au
SiteDoc - Easy to Use - Powerful Results
Is the following or statement the way to go or is there a better (ie
faster) way in which to obtain the same outcome.
if ((EXISTS(select DT from LETTERS_01 where DT=:FIND_ID))
or (EXISTS(select DT from LETTERS_02 where DT=:FIND_ID))
or (EXISTS(select DT from LETERS_03 where DT=:FIND_ID))) then Delete_OK
= -48;
tia
--
Regards,
Grant Brown
Product Development Manager
Phone : 02 4229 1185
Mobile : 0412 926 995
Email : grant@...
Web : www.sitedoc.com.au
SiteDoc - Easy to Use - Powerful Results