Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SOS please
Message
From
14/11/2001 11:05:57
 
 
To
14/11/2001 10:47:29
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00581460
Message ID:
00581555
Views:
19
Yes I agree.. in theory,
But there have been quite a few discussions regarding all this over the years and I think the general consensus is not to use pack (Hackers guide confirms this)
Will

>To Sheraz really (I cc'ed him/her)
>
>Something doesn't seem quite right here.
>
>PACK is supposed to make a copy into a new file, then delete the old (original) file.
>So IF the operation failed while the PACK was in progress (which would seem to be the case since the NOT ENOUGH SPACE message occurred during its run (or did it????), then everything should have been left as it was in the original file.
>
>I think we need more information here, most likely along the lines of precisely what actions were taken immediately after this message was seen. Also, confirmation that the message did, indeed, arise during the PACK itself.
>
>Jim
>
>>>I HAD A TABLE OF VFP 5.0. I RUN THE COMMAND PACK AND THE MESSAGE APPEARS THAT THERE IS NO ENOUGH SPACE ON THE SERVER. AND THEN THERE WERE 0 RECORDS SHOWN IN THE TABLE.
>>>
>>>THE PHYSICAL FILESIZE OF THE TABLE SHOWS THAT THERE SHOULD BE ABOUT 23000 RECORDS.
>>>
>>>PLEASE HELP ME FINDING A WAY TO RECOVER RECORDS FROM THIS TABLE.
>>>
>>>WAITING FOR AN EARLY REPLY.
>>
>>As Hilmar said.. revert to a backup it's probably easier
>>
>>There are also a number of .DBF fix tools floating around.. I remember there was one in Norton utilities
>>Or try opening the table in Excel
>>
>>Last resort?
>>Look up "table file structure" in help.
>>
>>Fact is it's probably dead
>>
>>P.S. You should never run Pack on a real table for exactly this reason. select from or copy to with cdx instead
Will Jones
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform