The problem now is that SQL doesn't seem to like the 'AND' in the second CASE line.
CASE tr.sTrans_Type_CD
WHEN 'PR' THEN tr.decTrans_Qty
WHEN ('PT' AND tr.decTrans_Qty > 0) THEN tr.decTrans_Qty
ELSE 0
END AS Receipt
"Incorrect syntax near the keyword 'AND'."
>>
>>SQL doesn't like the 'OR's and 'AND's
><snip>
>T-SQL doesn't like '.' (dots) arround them. There's no need to use dots in VFP either.
>
>CASE WHEN (TRANCODE = 'PR') OR (TRANCODE = 'PT' AND TRANQUANT > 0) THEN TRANQUANT
> ELSE 0 END AS Recepit
>
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people