this select crashed my compiled app

[Francois Van Lerberghe]

le 30/10/07 2:51, Joseph Morgan <joseph at checkos.com> a écrit :

> SELECT CASE WHEN arpaymentstatus = '0' THEN datediff(curdate
> (),accountsreceivable.arduedate,'day')END from accountsreceivable

Should not you add a space between the ending ")" and the END keyword ?

Like this :

SELECT CASE WHEN arpaymentstatus = '0' THEN datediff(curdate
(),accountsreceivable.arduedate,'day') END from accountsreceivable
                                     ^^^

François Van Lerberghe
Rue Thier Monty, 15 A
4570 Marchin
Belgique