Some of my code just broke under 9.

Is there an easy workaround to that VFP 9 sums 0 rows to .null.?

I have a statement report that accumulates a balance forward from
transactions. If there are none, then the total should be zero.
Instead, it sums to .null. I think that this is very silly.

I can patch this quickly enough, but there could be other similar
surprises waiting, so I would like a more general solution.

Sincerely,

Gene Wirchenko

Computerese Irregular Verb Conjugation:
I have preferences.
You have biases.
He/She has prejudices.

I use NVL() to translate null values to 0 or "".


"Gene Wirchenko" <genew (AT) ocis (DOT) net> wrote

You have to go with Dan's suggestion. SQL distinguishes between any non-zero
number of rows with a 0 sum and no rows at all. They're not the same and
it's the programmers job to handle the difference between the two.
-Lew
"Gene Wirchenko" <genew (AT) ocis (DOT) net> wrote