"Wron Expresssion" error on nested query

[Ruslan Zasukhin]

On 11/9/04 5:06 PM, "Frank Bitterlich" <bitterlich at gsco.de> wrote:

Hi Frank,

> I get a 616 error ("Wrong Expression") on the following query:
> 
> select * from NAVAIDS where (((LAT1<=28.60547) and (LAT1>=27.63281))
> and ((LON1>=-80.01172) and (LON1<=-78.43359))) or (((LAT2<=28.60547)
> and (LAT2>=27.63281)) and ((LON2>=-80.01172) and (LON2<=-78.43359)))
> 
> All fields (LAT1, LON1, LAT2, LON2) are VDouble.
> 
> What can be the reason? Is the query too long, or too deeply nested?

No and no.


>  I  have counted the parentheses, they appear to match. Or is there any
> stupid mistake that I'm overlooking?

I have check ()

All right.

Try remove some parts of exp to see which one cause problem



-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------