I frequently break up selects for readability by whomsoever will follow after me. I've managed to avoid awkward AND and OR logic - or at least limit it - by cascading selects.
- Charles "Readability" Barouch
Pingilley, Ron wrote:
The UV keyword REQUIRE.SELECT makes this a possibility. On the Mentor and Ultimate systems I cut my teeth on, if the 1st select returned zero records, then the second select would select against the entire file. Once I moved to UV, and learned about REQUIRE.SELECT, then breaking out SELECT statements made more sense.
--Ron P.
--
- Charles Barouch
(718) 762-3884 x 1 - Key Ally Voice Mail [EMAIL PROTECTED] - Consulting services
[EMAIL PROTECTED] - News
[EMAIL PROTECTED] - U2-Users Moderator [EMAIL PROTECTED] - Zeus Data Integration
Mount Olympus, Home of Zeus Data Integration
-------
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
