Hi all,

Here is the script. I am trying to update a 2.6 table from a remote view with the new ODBC driver. The view has only a few fields from the underlying table. When doing a tableupdate() I get an error message 581 "Field value does not accept null value." The error is generated by a field that's not in the view.

If I create a new view with all the table fields, and put a SPACE(0) as default value for character fields, 0 for numeric data, etc, the table updates just fine. Is there a better way to do that?

José