Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with inserting records in a view in a remote ser
Message
From
22/07/1999 15:31:06
 
 
To
22/07/1999 15:07:24
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00244909
Message ID:
00244929
Views:
13
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!
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform