Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Corrupt table
Message
From
25/04/2014 03:29:17
Metin Emre
Ozcom Bilgisayar Ltd.
Istanbul, Turkey
 
 
To
24/04/2014 15:07:23
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01598836
Message ID:
01599049
Views:
64
>>>Has the DBF file exceeded 2GB size? This could make repairs a wee bit trickier.
>>
>>This was a FP 2.6 and below issue. VFP doesn't let table exceed 2GB.
>I've seen situations in VFP applications where a table "crashed" because it went over the 2GB size limit -- the INSERT or APPEND command would indeed add a record and the record count would update -- but soon afterwards you'd get a runtime error. Indeed, as you say, VFP won't allow the table to exceed 2GB -- you get an error that point (unfortunately you still have a table that now cannot be opened). Fixing it requires that you either decrement the record count (and lose the last record added), or use an external program to effect the repair. The low-level file functions in VFP will work for the first type of solution, but not for recovery of any data past the 2GB size, as the low-level file functions in VFP appear to be subject to the same 2GB limitation.

You can't open files with VFP low-level file functions. I used Parserat for .DBF files exceeded 2GB.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform