incubator-ooo-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dan <elderdanle...@gmail.com>
Subject Re: BASE error: example Fuel Economy - SOLVED
Date Thu, 16 Aug 2012 17:07:44 GMT
JSz. wrote:
> I have edited the query in SQL view and I have manually changed the
> formulae:
>     "EndReading"."Odometer" - "Fuel"."Odometer" = '>=0'
>     "EndReading"."FuelID" - "Fuel"."FuelID" = '1'
> into:
>     "EndReading"."Odometer" - "Fuel"."Odometer" >=0
>     "EndReading"."FuelID" - "Fuel"."FuelID" = 1
> and saved the query.
>
> Now it works well.
>
> Jacek Szymona

      The Query Design dialog can introduce the problem you noticed: 
'>=0' and = '1'. While working to solve your problem, I opened the Query 
Design dialog several times. I specifically entered =1, but after a few 
close and open sequences, it became ='1'.
      The query will work just as well with >0 rather than >=0.

--Dan

---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org


Mime
View raw message