Probably you append blank in the view containing not all of the fields from the remote table. Or you did not set those fields as updatable for the view.


>Hello all, I am getting an error 1526 - cannot insert null into ... (table and field names).
>
>I have checked the values of the field it mentions and it is a char(1) and is receiving a space from append blank. But the tableupdate() is giving the aforementioned error. I checked whether there were any nulls in the field and non were found.
>
>Does anyone have a solution to this problem?
>
>Jason