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.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only