Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Correct way to call DBC stored procedure
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00523854
Message ID:
00524323
Views:
26
>Nadya,
>
>Make sure the view is updating you primary key field. If the primary key is not UPDATABLE in the view then you will get the results you are getting because VFP is not trying to write the primary key back to the table.
>
>Will

I never have the PK as an updatable field in my views if I have defined a function call to a SP as the default value for that field in my base table. When I issue the TableUpdate(), this SP fires when a new record is added. This always works because I use surrogate integer PKs that can never be changed by the user.
Mark McCasland
Midlothian, TX USA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform