Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Handling 1:M:M with views
Message
From
04/02/1999 23:58:54
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00184085
Message ID:
00184207
Views:
29
>If so, I think I see an easy solution. Your appended records (at least parent and child) need temporary surrogate keys to be assigned when created in the buffer.

Well, not temporary per se, only assigned earlier than normal. Kenneth has to be doing it this way anyway to add child records to a parent table whose records aren't yet commited.

something like

m.Pk = NewID('SourceTable')
INSERT INTO MyView FROM MEMVAR

Am I on track, Kenneth?

I am just brainstorming here.
I think the solution lies in two different form modes: one for viewing, and one for appending. Don't requery the grandchild view when changing the chld record pointer if the user is adding, maybe just set a filter or something, to get the records off of the screen. On stepping back from this mess, you might find it easier to build a smart cancel routine that will delete records that you had to earlier commit. Whew.
Erik Moore
Clientelligence
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform