Thanks Dennis. That's worth a lot more than 2 cents. I'll take your advice and it should be smooth sailing with no surprises. -- Fred ----- Original Message ----- From: Dennis McGrath To: RBASE-L Mailing List Sent: Wednesday, May 28, 2008 11:32 AM Subject: [RBASE-L] - RE: AND / OR processing
Fred, Using AND OFF sets you up to trip over CFG file inconsistencies, not to mention that you code will not be portable if you decide to use another front end. Stick with the standard SQL syntax and your code will always run as you expect. Whenever I have Ors, I make sure to properly parenthesize my where clauses so there is never a question about my intent. Get used to this and you can create clauses that do elaborate mixes of ORs and ANDs to really streamline things when necessary. My 2 cents Dennis McGrath ------------------------------------------------------------------------------ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Fred C Kopp Sent: Wednesday, May 28, 2008 10:22 AM To: RBASE-L Mailing List Subject: [RBASE-L] - AND / OR processing Good morning from PA, I built a simple application with Application Designer that calls up various subsets of a union membership to eyeball compare with paper dues reports. Some of the Where clauses use OR. I like to SET AND OFF because I'm so used to that. I place the OR statements first and they get processed first. It works fine when I RUN the application directly, but I want to LAUNCH the app from a Main Menu just like RRBYW14 (thank you, Razzak). When I do that, the OR statements are ignored UNLESS I enclose them in parentheses, just as the Help advises you to do when AND is set ON. It's almost as though AND is being switched ON somewhere. Yeah, like I'd know that. You know what? I don't complain as long as I can swerve into a solution. Just curious if anyone else has thoughts on this. I'm having fun! Fred Fred C. Kopp Authorized R:Base Developer 19 Teri Lane Washington, PA 15301 P 724-222-7376 F 724-222-7376 C 724-413-5534 E [EMAIL PROTECTED]
