Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Data archtectural conundrum
Message
From
17/10/1999 18:02:49
 
 
To
17/10/1999 14:55:11
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00277457
Message ID:
00277479
Views:
22
Hi Erik ---

>It's probably not the most desirable, but I force the user to deal on a child by child basis. IOW, before adding grandchildren to a different parent, they have to save the ones they were adding. IOW, it becomes a parent-centric process instead of a grand-parent centric process.

I'd hate to do that. I'm kinda steering that way now but it'd break the UI metaphor for the application that I have established, which is Apply saves all changes to all, Undo reverts all.

>But here's an idea if you don't like that: Define your grandchild view to hold all of the forms for all of the steps for a given process. Then set filters when switching beween parents. This way all of the records stay in the same cursor, with no need to commit when switching Process steps. When the user is ready to save everything, remove the filter and TABLEUPDATE().

That's an intriguing idea. I think I'll try that one. How about this, I have been considering using TRANSACTIONS when the edit starts and either END or ROLLBACK as appropriate when the user hits Apply or Undo. What do you think of that?
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform