Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Handling 1:M:M with views
Message
De
04/02/1999 23:58:54
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00184085
Message ID:
00184207
Vues:
28
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform