Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
View Puzzler
Message
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Miscellaneous
Thread ID:
00119767
Message ID:
00119866
Views:
20
Peter,

That's your problem. To create an updatable view your table must have a primary key. This is because VFP uses the SQL UPDATE command which needs some criteria to determine which record(s) to update. It is fairly standard when using SQL databases to require a primary key for every table.

>John,
>all the settings are set as you specify, but the field marked as the key is not unique as it's a child table
>Pete Kane
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform