View Single Post
  #8  
Old 01-24-2009, 07:55 AM
ashwken ashwken is offline
Registered User
 
Join Date: 10-16-2005
Location: Blairsville, GA USA
Posts: 431
Quote:
Originally posted by quant
I already requested this, but got no reply.

Anyway, if you didn't indent the last row the search would be (as far as I know):

you have two AND and one OR on the same level (the order on the same level does not matter, read in the help file "location does not matter"), by the help file AND takes precedence (all AND are evaluated before any OR, on the same level), so you have

(Reminder > 0 AND Begin Date >= 12/25/2008 AND Begin Date <= 01/30/2009)
OR
Date Completed .NOT. exists

Now you connect the above with AND on the second level, so you get


((Reminder > 0 AND Begin Date >= 12/25/2008 AND Begin Date <= 01/30/2009)
OR
Date Completed .NOT. exists)
AND
Date Completed = NULL
So, the positioning of the indent(s) within the grid (which row they occupy) has no bearing on the evaulation sequence, except that the rows are evaluated by position within an indent level with .AND. taking precedence.

In the above example, the indented row could actually be the last row of the grid?
Reply With Quote