Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Saving from working table
I have a working copy of one of my tables. I make some changes to the to the working table because I don't want to save the additions until save has been pressed but I can't get only the records added to the working table saving to the real table. I had a similar problem with deleting from the working table. And this is how I solved that:
set deleted off
select wkinvdetail
set order to manifestno
select invdetail
set relation to manifestno into wkinvdetail
locate
delete for !eof("wkinvdetail") ;
and deleted("wkinvdetail") ;
and !deleted("invdetail");
in invdetail
set relation to
tableupdate(.T.)
I think it would be something similar but can't figure it out.
TIA,
Tyler
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement