*Hi Kathy Morris,*
Your second part of the question-->*
Sometimes when I use LIKE %Mary Smith I find the name faster than if I
type = "Mary Smith" - never understood why.
*
*
Answer-->*
A search on a character field with a QBE match type of "Anywhere"
performs a full table scan of the database
*Hi Kathy Morris,*
When you use multiple operators to construct qualification criteria,
they are evaluated in the following order:
1. |( )|
2. |NOT (!) -| (unary minus)
3. |* / %|
4. |+ -|
5. |< <= > >= = != LIKE|
6. |AND (&&)|
7. |OR (||)|
Operators of the same precedence are p
PLUS
this qualification.
If they had all been "or", or "and", it wouldn't have been a problem.
Hope that helps.
-Original Message-
From: Kathy Morris <[EMAIL PROTECTED]>
Sent: Tuesday, May 20, 2008 7:26 PM
To: arslist@ARSLIST.ORG
Subject: Qualification Error - Strang
The first qualification would be interpreted as:
('Assignee+' = "Michael Davis") OR (( 'Assignee+' = "Gurpreet Savi") AND
('Status*' <= 3))
That explains the result return all entries with Status as they match with
"Michael Davis"
AF
On Tue, May 20, 2008 at 5:27 PM, Kathy Morris <[EMAIL PROTECTE
: Tuesday, May 20, 2008 8:27 PM
To: arslist@ARSLIST.ORG
Subject: Qualification Error - Strange?
Hello all,
I ran this qualification:
'Assignee+' = "Michael Davis" OR 'Assignee+' = "Gurpreet Savi" AND 'Status*'
<= 3
Result: status values
Hello all,
I ran this qualification:
'Assignee+' = "Michael Davis" OR 'Assignee+' = "Gurpreet Savi" AND 'Status*'
<= 3
Result: status values that such as Closed and Cancelled appeared that have
a value of 5 and 6??
When I modified the qualification:
('Assignee+' = "Michael Davis" OR '
6 matches
Mail list logo