Hi Kevin,

Don't know if this will help but here goes :)

Is the PK field and integer? If so and you append blank in the view, the PK field will show a 0. In the view it's not blank, but if you try to update the view it will (afa I can tell) try to insert a .null. into the table. Try to replace the PK before doing the tableupdate and see what happens. Also check the base tables and see if "allow null" is different for the ones that don't work from the ones that do.

AFA the "Cannot insert an empty record into base table" error means you are trying to append blank to the view and not putting any value into the view fields. Are you doing a join in the SQL for the view? I had one view that had a table name for an non-updatable field in the view that caused that error.

DL eView from the ut. It will let you generate the code used to create the view and you can look and see exactly how the view works. It's in the files section
under :Visual FoxPro in general" File#9474.

IAC, I'm really figuring out the way these things work myself, and I've had similar problems that have all related to appending blank and getting what I think is a value (when vfp tries to insert a .null.)

hth


>I've checked everything, I've packed the base table to clear everything, but the message is still there, I have also double-checked the PK on the base table.
>
>Recently, when attempting this, I got the "Cannot insert an empty record into base table", then when I tried immediately after, I got the PK error.
>
>Sounds a bit dodgy to me??!!!
>
>Kev