Hi Lutz,
thanks a lot for your help.
Best regards
Thomas
>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
Hallo Thomas,
- not that I know of a setting
- do not use NVL, use ... WHERE kundennr = 9999999 AND betrag IS NOT NULL instead. You wouldn't like to sum the nulls anyway?
I think the result .NULL. is correct and better then 0. .NULL. is to be read as
I don't know, so number +
I don't know is equal
I don't know, not 0
(Watch out the boolean operators with .NULL. for example 1 AND .NULL. equals .NULL. while 0 AND .NULL. equals 0, .OR. does the opposite, this is determined by boolean logic and perfectly fine)