Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
One to many updatable form
Message
De
28/11/1997 23:10:39
George Alexander
Qatar Armed Forces
Doha, Qatar
 
 
À
28/11/1997 15:00:58
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Divers
Thread ID:
00062681
Message ID:
00062833
Vues:
54
>>First). I am using table buffering. I use child cursor so that the user will be able to add records without affecting
>>the table.
>
>With table buffering, you could do an APPEND BLANK directly in the child table. The changes won't be send to the tables until you issue a TABLEUPDATE(). VFP do directly what you are doing by code.
>
>>2. I copy the records of the child cursor into array and use insert(SQL) into the child table and then give the
>>tableupdate.
>
>Do you verify the result of TABLEUPDATE()? It return .F. if the change were unsuccessful.


1. I dont know where to put the append blank. What I want is when the user clicks the grid for the first time
a blank record should be added and then when he presses down arrow more records should be added. He
will also have the freedom to click on the deleted mark to delete one or all of the child records. All this facility
is only in add mode which I keep track by setting a flag as soon as he clicks add button.

2. I have included a On Error errflag = .t. statement as Mr. Eric has suggested in one of a previous thread. But
it is not going to the roll back as far as the master table is concerned. So I end up with a master record without
a child record

thanks for the reply

alex
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform