V4RB SQL Select Problem

[Cindy]

Hi Ruslan,

I am aware of the lock parameters and have these in place. When I run the
query in viSQL it gives me a 616 error which I presume means my query is not
correct but the fields are fine. They're all there and the methods are fine
so I'm not sure exactly what is the problem here.

Cindy

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