Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Editing multiple records of a table in the same form
Message
 
To
16/09/2009 01:47:58
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01424677
Message ID:
01424688
Views:
74
> could it be possibly done by using a single view?

No, views don't work particularly well with more than one update table. While changes appear to work, you get into real problems when you delete one of the n-records. As there's only one deleted flag, this would also delete the parent record which often cascades and deletes all other child records, as well. The rule of thumb is one updateable table per view.
--
Christof
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform