Mass undelete records in a DBF-file - SOLVED

[driessen]

A customer of mine deleted a few thousand records in a DBF-file.

They are still there of course but they are all marked as deleted.

How can I undelete all those records?

Thank you very much in advance for any help.

[Bayron]

You have to use the RECALL command...

http://www.ousob.com/ng/53guide/ngd675b.php

EDITED: You have to test it, because I only see this documentation on Harbour:

http://www.fivetechsoft.com/harbour-docs/api.html#dbrecall

[Bayron]

Before you try anything, make sure you make a copy of the affected database...

If I understand correctly, dbRecall() recalls only the record where the pointer is at...

So you probably can try:

DBEVAL()

Performs a code block operation on the current Database

Syntax
DBEVAL( <bBlock>,
[<bFor>], [<bWhile>],
[<nNext>], [<nRecord>],
[<lRest>] ) --> NIL
Arguments
<bBlock> Operation that is to be performed

<bFor> Code block for the For condition

<bWhile> Code block for the WHILE condition

<nNext> Number of NEXT records to process

<nRecord> Record number to work on exactly

<lRest> Toggle to rewind record pointer
Returns
DBEVAL() always returns NIL

Description
Performs a code block operation on the current Database

I never had the need to recover any records, but you can start from there...
Please post your results, so we can learn from it...

[Enrico Maria Giordano]

If I understand correctly, dbRecall() recalls only the record where the pointer is at...

No:

Code: Select all  Expand view

RECALL FOR condition

EMG

[driessen]

Thanks a lot, guys.

Your help was all very helpful.

It was the first time I had to do that. And thanks to you all with succes.

[Franklin Demont]

Michel

All the indexes have to be rebuild , or when the dbf is packed the index should be active

Frank

[Bayron]

I am glad you succeeded...
Anyone's problems is a school for all of us...