this select crashed my compiled app

[Ruslan Zasukhin]

On 30/10/07 4:51 AM, "Joseph Morgan" <joseph at checkos.com> wrote:

> 
> 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?

Yes please report, and of course attach simple small db with query that
reproduce this crash.

Also OS and version info as always.

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]