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.
--Todd Sherman
-Wake Up! Smell the Coffee!