ADOCE 3.1 trouble 
Author Message
 ADOCE 3.1 trouble

Can anyone tell ne why the two statements below give different results?

The first statement returns 0 records while the second statement returns
(correctly) 2 records.

1)    SELECT * FROM Locations WHERE ((Locations.LocDead)=False) AND
((Locations.LocName) Like "*fred*" OR (Locations.LocAddress1) Like "*fred*")
AND ((Locations.LocType)='R');

2)    SELECT * FROM Locations WHERE (((Locations.LocDead)=False) AND
((Locations.LocName) Like "*fred*" OR (Locations.LocAddress1) Like
"*fred*")) AND ((Locations.LocType)='R');

Am I going to have to pad my statements with even more brackets infuture or
is there a simple explanation I am overlooking?

Any help gratefully received!

Simon Waters



Sun, 26 Sep 2004 19:36:08 GMT  
 ADOCE 3.1 trouble
Check your parenthesis according to what you want.


Quote:
> Can anyone tell ne why the two statements below give different results?

> The first statement returns 0 records while the second statement returns
> (correctly) 2 records.

> 1)    SELECT * FROM Locations WHERE ((Locations.LocDead)=False) AND
> ((Locations.LocName) Like "*fred*" OR (Locations.LocAddress1) Like
"*fred*")
> AND ((Locations.LocType)='R');

> 2)    SELECT * FROM Locations WHERE (((Locations.LocDead)=False) AND
> ((Locations.LocName) Like "*fred*" OR (Locations.LocAddress1) Like
> "*fred*")) AND ((Locations.LocType)='R');

> Am I going to have to pad my statements with even more brackets infuture
or
> is there a simple explanation I am overlooking?

> Any help gratefully received!

> Simon Waters



Sun, 26 Sep 2004 21:44:59 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Getting ADOCE 3.1 installed on an old iPAQ 3650 Pocket PC 2002

2. ADOCE 3.1 - System Hang

3. SQLCE2.0 and ADOCE 3.1 Connection Property

4. ADOCE 3.1

5. How to install MS ADOCE 3.1 ??

6. ADOCE 3.1 and Where Clause

7. ADOCE 3.1 Access Specifications

8. SEEK Method in ADOCE 3.1

9. ADOCE 3.1 PROBLEM IN EMULATOR AS TARGET DEVICE

10. Install Wizard only sees ADOCE 3.0 (not 3.1)

11. ppc 2002,evb 3.0,adoce 3.1 Can't create object

12. Does ADOCE 3.1 do weird things to eVB?

 

 
Powered by phpBB® Forum Software