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