|
| Problem with APPEND FROM |
 |
Thu, 13 Mar 2008 09:57:26 -050 |
I am trying to append record from a Dbase plus file in another Dbase plus file
and all deleted record are append even if the Set deleted is on. What is the
problem ?
|
| Post Reply
|
| Re: Problem with APPEND FROM |
 |
Thu, 13 Mar 2008 12:43:23 -040 |
In article <fr0eNqRhIHA.2000@news-server>, nhandfield@sysmic.com says...
> I am trying to append record from a dBASE plus file in another
> dBASE plus file and all deleted record are append even if the
> Set deleted is on.
Does the clause "for true" makes a difference, as in this example:
append from Source_Table for true
Jean-Pierre Martel, editor
The dBASE Developers Bulletin
|
| Post Reply
|
| Re: Problem with APPEND FROM |
 |
Thu, 13 Mar 2008 23:48:05 -040 |
In article <fr0eNqRhIHA.2000@news-server>, nhandfield@sysmic.com says...
> I am trying to append record from a Dbase plus file in another Dbase plus
file and all deleted record are append even if the Set deleted is on. What is
the problem ?
>
>
Norman,
dBASE appends first and asks questions later. If this is a one time task
of appending table B to table A, you could copy table B to C. This will
copy only the valid rows of table B (not the deleted ones). THen, append
table C to table A.
--
Geoff Wass [dBVIPS]
Montréal, Québec, Canada
.|.|.| dBASE info at http://geocities.com/geoff_wass |.|.|.
.|.|.| ---------------------------------------------------------- |.|.|.
|
| Post Reply
|
|
|
|
|
|
|
|
|
|