Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Editing multiple records of a table in the same form
Message
From
16/09/2009 12:22:33
 
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:
01424757
Views:
53
>> 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.

Hi,

Thanks for pointing out this delete problem, although it is not a real problem this time...

The reason I don't want to use grid is because the 1+N records are logically bound as one entity, that is when ADD, 1+N records must be appended at the sametime and the samething apply to deletion.
Previous
Reply
Map
View

Click here to load this message in the networking platform