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