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