>I just upgraded to V9 from V8 and now my application is giving some wierd errors.
>
>Field XYZ does not accept null values.
>
>This is generally happening on recalc processes that affect the values in text fields that are bound to a table/field when there is no data. In version 8, I did not get this error message. Is this like the GROUP BY problem when upgrading from V7 to V8? Do I need to change all my fields to allow null values, or is there a better way to handle this?
>
>Thanks,
>
>Randy Wessels
This is another of the SQL differences in VFP9. This is more in-line with the way that SQL server works, you get a null record returned, whereas before, you used to get an empty cursor returned. I do believe it's documented in the WHATSNEW or somewhere, I know I read it (and was bitten by it, too).