this select crashed my compiled app
Joseph Morgan
joseph at checkos.com
Mon Oct 29 20:51:12 CDT 2007
Crashes app, not exception.
Heres the select:
SELECT CASE WHEN arpaymentstatus = '0' THEN datediff(curdate
(),accountsreceivable.arduedate,'day')END from accountsreceivable
The two parts work separately:
SELECT CASE WHEN arpaymentstatus = '0' THEN '---' from
accountsreceivable
SELECT datediff(curdate(),accountsreceivable.arduedate,'day') from
accountsreceivable
It seems that mixing the CASE WHEN and the DATEDIFF together cause
the crash.
Also this only seems to happen only in v4rb, because it works great
in vstudio.
It looks like a bug. Should I report to mantis?
Joseph
More information about the Valentina
mailing list