Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cannot update data in multi-table view
Message
From
07/06/2006 18:49:38
 
 
To
07/06/2006 12:01:20
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01127605
Message ID:
01127718
Views:
10
Multiple views is definatley the way to go.

I've done table updateable views, but only for updating a single table and having the child or parent info in the view for display purposes. I would never change a primary key in a view, indeed I'd never change a primary key at all once it has been created.

Sounds more like you need a paramerterized view that is requeried based on the parent tables primary key.
Sigfried Trent, aka FoxMan
(Working from his secret code cave, FoxMan battles the forces of darkness lead by the deranged and mysterious Bug Boy)
Previous
Reply
Map
View

Click here to load this message in the networking platform