V4RB SQL Select Problem
Cindy
alvin at ins.co.nz
Tue Oct 14 16:49:35 CDT 2003
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.
More information about the Valentina
mailing list