Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
DBF 2g bytes but 0 records.
Message
From
17/01/2002 14:23:42
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00606242
Message ID:
00606289
Views:
18
>>>One of my co workers was doing an insert into a dbf and the file size was over 2GB but the record count was 0.
>>>
>>>Have any of you ever had this problem? If so, what can cause this problem?
>>
>>I guess there was a lot of deleted records.
>
>Or was the header record already corrupted perhaps, due to the 2GB+ attempt? COUNT and RECCOUNT() both recognize deleted records when DELETED is OFF. COUNT doesn't recognize deleted records when DELETED is ON. Zat correct?

What I find weird is that if something is corrupted, you'll normally won't be able to access the table and you'll get a message.

As for SET DELETE ON, COUNT won't count them. But, if you work with SET DELETE OFF, then, there's no filter.

Did you try to open exclusively and pack? After that, what is the current situation?
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform