V4RB SQL Select Problem

[Cindy]

Hi Ruslan,

I did a bit of playing around and changed my method name from Age-3 to AgeN3
and the select works fine now. I think that 1.9.8 must not like me using -
or + in the name of a field. Is this a fault or should I normally be
avoiding those characters?

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.