General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only