Re: dynamic criteria being ignored by query

From	"David-W-Fenton" <NoEmail@SeeSignature.invalid>
Newsgroups	comp.databases.ms-access
Subject	Re: dynamic criteria being ignored by query
Date	2011-04-09 21:22 +0000
Organization	David Fenton Associates
Message-ID	<Xns9EC2B0AB8E45Bf99a49ed1d0c49c5bbb2@74.209.136.89> (permalink)
References	<5c35353f-1827-4170-bc4e-57826cf3522c@d28g2000yqf.googlegroups.com> <Xns9EBF871C0F996f99a49ed1d0c49c5bbb2@74.209.136.92> <inlab8$jk6$1@dont-email.me>

Show all headers | View raw

"Douglas J Steele" <NOSPAM_djsteele@NOSPAM_gmail.com> wrote in
news:inlab8$jk6$1@dont-email.me: 

> According to the Help file, the precedence of boolean operators is
> Not, And, Or, Xor, Eqv, Imp
> 
> Doesn't that mean that
> 
> WHERE condition1 OR condition2 AND condition 3
> 
> will always be evaluated at
> 
> WHERE condition1 OR (condition2 AND condition 3)

I don't know. I wouldn't take a chance. I am very much against
relying on implicit behaviors when you can specify what you want
explicitly and then be entirely certain what will happen. 

-- 
David W. Fenton                  http://www.dfenton.com/ 
contact via website only     http://www.dfenton.com/DFA/

Back to comp.databases.ms-access | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

dynamic criteria being ignored by query Tony_E <bluestealth94@hotmail.com> - 2011-04-05 05:16 -0700
  Re: dynamic criteria being ignored by query "zuckermanf@gmail.com" <zuckermanf@gmail.com> - 2011-04-05 07:52 -0700
    Re: dynamic criteria being ignored by query Tony_E <bluestealth94@hotmail.com> - 2011-04-05 07:57 -0700
      Re: dynamic criteria being ignored by query John Spencer <JSPENCER@Hilltop.umbc> - 2011-04-05 11:36 -0400
        Re: dynamic criteria being ignored by query Tony_E <bluestealth94@hotmail.com> - 2011-04-05 08:46 -0700
  Re: dynamic criteria being ignored by query "David-W-Fenton" <NoEmail@SeeSignature.invalid> - 2011-04-06 17:16 +0000
    Re: dynamic criteria being ignored by query "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_gmail.com> - 2011-04-07 17:29 -0400
      Re: dynamic criteria being ignored by query "David-W-Fenton" <NoEmail@SeeSignature.invalid> - 2011-04-09 21:22 +0000
        Re: dynamic criteria being ignored by query "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_gmail.com> - 2011-04-10 09:12 -0400

csiph-web