Hello...

I´m using Baan5C with Informix database, I have a report with an integer field that I use for the year. I'm using set.max(year) for the variable, but when I´m retrieving information from a query to the database the query doesn´t works fine.

set.max(year)...

select .....
from...
where...
table.fiel < :year ....

Then I discovered that if I change the value running the debugger for example: year :=2006 it works.

Does somebody have any idea about how to avoid this problem??? I've tried the same running under Oracle db and I haven't had any trouble doing that....

Thanks.
LOBO SLFNOVA:o

Try to extend the set.max call with the domain you are using. like:

set.max(year, "tc.year")

Hope this helps,
Dick

Thank you Dikkie Dik, your solution works fine.