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