Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Saving from working table
Message
From
13/06/2001 12:32:42
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Saving from working table
Miscellaneous
Thread ID:
00518957
Message ID:
00518957
Views:
42
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
Next
Reply
Map
View

Click here to load this message in the networking platform