Thanks for the answer. It seems that I didn't mark the key field (as key fields) for the non-updateable tables in the view. As soon as I did, everything worked fine.
John
>Hi,
>It seems some fields in the table set as NOT NULL in SQL database.
>You may change the table setting OR update the field with SPACE or 0 (depends on the data type).
>
>Wilfred
>
>>I have a remote view (SQL) with 3 tables. Only one is marked as updatable. When I try to save a new record I get an ODBC error that a NULL value is not allowed in one of the fields in a table that is not being updated.
>>
>>TIA
>>
>>John
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement