General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>Huh ??? I remember struggling with this about a year ago. I mean, I wanted it to work like you describe but couldn't come to that. And the Help on it was clear enough. What did you do in order to let it work like this ?
>What version do you use (I have VFP5 no SP).
>
>curious ...
using vfp6sp4
just tried a few things...
the append will respect the state of set deleted, sort of. if records are marked deleted and SET DELETED OFF, then all records are copied, and the taget table will maintain the deleted flag. if SET DELETED ON, the deleted recored are not copied at all ( not there ever if changing to SET DELETED OFF ).
one way to obtain the resaults you seem to request is :
nLastrecno = recno("targetTable") && store last recno in table
cLastDelState = set("deleted")
set deleted off
select targetTable
append from dbf("SourceTable")
goto record nLastrecno && the last record b4 the additions
recall rest
set deleted &cLastDelState
- jer
Previous
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