|
Home > Archive > dBASE Questions and Answers > December 2006 > dBASE/DOS IV or dBASE/DOS 5.0 question
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
dBASE/DOS IV or dBASE/DOS 5.0 question
|
|
| Ken Mayer [dBVIPS] 2006-12-08, 7:20 pm |
| I have a customer who needs to look at his data, and undelete specific
records that have been deleted (and undelete them in specific cases).
I cannot figure a way for him to do this, just showing the deleted
records ... in 5.7 the following works:
set deleted off
use tablename
browse for deleted()
However, apparently this last statement does not work in dBASE IV or 5.0
(DOS).
Any suggestions?
Ken
--
/(Opinions expressed are purely my own, not those of dataBased
Intelligence, Inc.)/
*Ken Mayer* [dBVIPS]
/Golden Stag Productions/
dBASE at goldenstag dot net
http://www.goldenstag.net/dbase/dBASEBook.htm
http://www.goldenstag.net/GSP
http://www.goldenstag.net/dbase
| |
| Vasile Buza 2006-12-08, 7:20 pm |
| You can try:
set deleted off
use tablename
set filter to deleted()
browse
Vasile Buza
"Ken Mayer [dBVIPS]" < dbase@_nospam_golden
stag.net> wrote in message
news:L71pv4sGHHA.1904@news-server...
>I have a customer who needs to look at his data, and undelete specific
>records that have been deleted (and undelete them in specific cases).
>
> I cannot figure a way for him to do this, just showing the deleted records
> ... in 5.7 the following works:
>
> set deleted off
> use tablename
> browse for deleted()
>
> However, apparently this last statement does not work in dBASE IV or 5.0
> (DOS).
>
> Any suggestions?
>
> Ken
>
> --
> /(Opinions expressed are purely my own, not those of dataBased
> Intelligence, Inc.)/
>
> *Ken Mayer* [dBVIPS]
> /Golden Stag Productions/
> dBASE at goldenstag dot net
> http://www.goldenstag.net/dbase/dBASEBook.htm
> http://www.goldenstag.net/GSP
> http://www.goldenstag.net/dbase
| |
| David Kerber 2006-12-08, 7:20 pm |
| In article <L71pv4sGHHA.1904@news-server>, dbase@_nospam_golden
stag.net
says...
> I have a customer who needs to look at his data, and undelete specific
> records that have been deleted (and undelete them in specific cases).
>
> I cannot figure a way for him to do this, just showing the deleted
> records ... in 5.7 the following works:
>
> set deleted off
> use tablename
> browse for deleted()
>
> However, apparently this last statement does not work in dBASE IV or 5.0
> (DOS).
>
> Any suggestions?
set filt to dele()
brow
Works in dBase IV ver 2
--
Remove the ns_ from if replying by e-mail (but keep posts in the
newsgroups if possible).
| |
| Thorsten Hill 2006-12-08, 7:20 pm |
| Ken Mayer [dBVIPS] Wrote:
> set deleted off
> use tablename
> browse for deleted()
>
> However, apparently this last statement does not work in dBASE IV or 5.0
> (DOS).
>
> Any suggestions?
list for deleted()
or
set filter to deleted() = .t.
browse
| |
| Ken Mayer [dBVIPS] 2006-12-08, 7:20 pm |
| Vasile Buza wrote:
> You can try:
>
> set deleted off
> use tablename
> set filter to deleted()
> browse
I tried this in 5.7 and it gave me no records in a table where there are
at least a thousand deleted records ...
Ken
--
/(Opinions expressed are purely my own, not those of dataBased
Intelligence, Inc.)/
*Ken Mayer* [dBVIPS]
/Golden Stag Productions/
dBASE at goldenstag dot net
http://www.goldenstag.net/dbase/dBASEBook.htm
http://www.goldenstag.net/GSP
http://www.goldenstag.net/dbase
| |
| Ken Mayer [dBVIPS] 2006-12-08, 7:20 pm |
| David Kerber wrote:
> In article <L71pv4sGHHA.1904@news-server>, dbase@_nospam_golden
stag.net
> says...
>
>
>
> set filt to dele()
> brow
>
> Works in dBase IV ver 2
>
Okay. Well, I suggested that to the client, but when I tried it in 5.7
yesterday it returned zero records in a table with well over 1000
deleted records. I guess we'll see.
Ken
--
/(Opinions expressed are purely my own, not those of dataBased
Intelligence, Inc.)/
*Ken Mayer* [dBVIPS]
/Golden Stag Productions/
dBASE at goldenstag dot net
http://www.goldenstag.net/dbase/dBASEBook.htm
http://www.goldenstag.net/GSP
http://www.goldenstag.net/dbase
| |
|
|
| Gerald Lightsey 2006-12-09, 12:15 am |
| On Fri, 08 Dec 2006 05:26:39 -0800, in the dbase.how-to group, Ken Mayer
[dBVIPS] said...
> I have a customer who needs to look at his data, and undelete specific
> records that have been deleted (and undelete them in specific cases).
>
> I cannot figure a way for him to do this, just showing the deleted
> records ... in 5.7 the following works:
>
> set deleted off
> use tablename
> browse for deleted()
>
> However, apparently this last statement does not work in dBASE IV or 5.0
> (DOS).
>
> Any suggestions?
set deleted off
dd a logical field named something like "Flag".
replace flag with .true. for deleted()
set filter to flag or index on whatever for flag
delete/recall until the project is finished
remove the flag field
Gerald
|
|
|
|
|