How to delete all records in a DBF - Visual Fox Pro 1

[MohdSuffian]

thread184-517186

how to delete all record in a dbf?

I would recommend like this:

SELECT tablename
DELETE ALL
PACK

or

SELECT tablename
ZAP

Regards
Mohd Suffian

 

[Phil Thoms]

Hello Mohd Suffian,

use tablename
zap
pack


Regards,
Phil

 

[Mike Lewis]

So what is your question?

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads

 

[Mike Lewis]

use tablename
zap
pack

Phil, there is no point in doing both PACK and a ZAP. Once you have zapped, there are no records left to pack.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads

 

[Phil Thoms]

Hi Mike,
Of course you're right, haven't zapped for ages.
Only pack after deleting a few records.

Regards,
Phil

 

[tomk3]

Hello,

as far as I know zap is much faster.
Both (zap or delete all + pack) need exclusive access.

Regards
tom

 

[Mike Lewis]

Your're right, Tom. PACK is the slowest because it involves copying all the records in the table, deleted or otherwise. With ZAP, VFP simply has to change one field in the table header.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads