Hi Brenda,

to be comliant with ANSI SQL, you now must either list ALL the fields in the insert statement, or make all the fields which you do not include, nullable.

>In switching the VFP9, I now am getting quite a few FIELD fieldname DOES NOT ACCEPT NULL VALUES. This is obviously in the INSERT and APPENDS. Do we have to redo all the table definitions to allow NULL values? Was there not the concept of NULL values in VFP6? Trying to understand what was inserted in VFP6 vs what would happen if I allow NULL values to be inserted in VFP9.
>
>Thanks
>
>Brenda