Hi Naomi,

thank you for your advise.

Best regards

Thomas

>Take a look at the SET ENGINEBEHAVIOR setting in Help. I would >recommend to add NVL in code after getting the result, though.

>Hi there,
>
>in VFP8 I could do the following qzery:
>

>SELECT sum(betrag) FROM faktur WHERE kundennr = 9999999 INTO Cursor mycursor WHERE kundennr = 9999999
>

>and get a Cursor with a numeric field (or an array[1]-value) containg the value 0 when the query did not get any records.
>
>In VFP9 I get the field of my result-cursor filled with .NULL.
>I know I could use the nvl-function zo get the result as number 0 but I would like to know if I have missed a setting in VFP9 to emulate the old behaviour.
>
>Best regards
>
>Thomas