V4RB SQL Select Problem

[Ruslan Zasukhin]

on 10/13/03 23:16, Cindy at alvin at ins.co.nz wrote:

> Hi,
> 
> I was wondering if anyone can tell me where I am going wrong.
> 
> This select was working on 1.9.7 but now on the latest download (1.9.8) it
> is crashing my program:
> 
> Select Last_PreferredName, Room, Year, Gender, Date_Started_School,
> Ministry_Year From Students WHERE Age_Years <= 8 AND Ministry_Year >= Age-3
> 
> If I take the last bit off (Ministry_Year >= Age-3) then the query works.
> 
> Ministry_Year is a Short Field.
> 
> Age-3 is a Float field with a method. The method calculates correctly. It's
> just the comparison that fails.

Hi Cindy,

First of all, since you have problems with 1.9.8 switch:
    -- are you aware about new record locks parameters?

If no then this can be reason.
Please read docs about SqlSelect() new parameters.


If this is not an issue, then you can try do that query from visQL to see if
it crashes.

-- 
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
-------------------------------------------------------------