Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Saving from working table
Message
De
13/06/2001 12:32:42
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Saving from working table
Divers
Thread ID:
00518957
Message ID:
00518957
Vues:
43
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
Fil
Voir

Click here to load this message in the networking platform