That's it! I forgot to mark the primary keys as updateable (the default is not updateable for PK)!
Thanks,
Augusto.
>I had that problem too. Its turns out that my keyfields were marked as not update-able. So when I tried to insert a record, it left the keys blank.
>
>>I have a view based on a table stored on sql 7.0 database. That view is updatable and I am using row buffering. When I insert a new record in that view using INSERT-SQL , I got the message:
>> “Connectivity Error – Cannot insert the value NULL into column ‘IDPRJ’, TABLE...;column does not allow nulls.Insert fails.”
>>I AM QUITE SURE THAT I’M NOT INSERING NULL VALUES IN THAT COLUMN (PK). What’s going on??
>>
>>Regards,
>>Augusto.
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