Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Not a table
Message
From
02/02/2005 04:35:46
Metin Emre
Ozcom Bilgisayar Ltd.
Istanbul, Turkey
 
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Title:
Miscellaneous
Thread ID:
00982401
Message ID:
00982972
Views:
23
Don't be any misunderstand. Parserat can't help you use ".dbf's exceeded 2 GB" with foxpro. It help you reaccess your .dbf's only for repair.

You can open any dbf exceeded 2 GB with parserat. so than you can parse your table or you can change any text field size lower than 1 byte and save. than your .dbf file accesible from vfp...

>Thank you, it is interesting. Could you share your experience with "parserat"? Do you incorporate it somehow in your VFP application?
>
>>At least VFP9 will warn you about 2 GB. :) If you have files bigger than 2 GB you can use parserat for access your files...
>>
>>>Alex, could you clarify why VFP9 will help in this situation? As far as I know, it still has the 2 GBt limit.
>>>
>>>
>>>>>The dbf file is about 2 000 000 KB, the FPT file is about 450 000 KB and the CDX file is about 41 000 KB. The file was created, and is largely accessed, using VFP 6.0 (although some clients are moving to 9 BETA).
>>>>
>>>>Are you saying the DBF weighs 2GB? Then you are hitting the upper limit for a VFP file.
>>>>
>>>>Options:
>>>>- trim the file
>>>>- narrow it (less columns)
>>>>- move to SQL Server or similar
>>>>- partition the file vertically into separate files (a PITA to query and deal with).
>>>>
>>>>
>>>>although some clients are moving to 9 BETA
>>>>
>>>>BAD idea! You should not give customers a Beta product. Betas are by definition test versions (incomplete products). They are also bloated with test code and therefore slower. The VFP 9 Public Beta was incomplete in some of its functionality. And besides it will expire in a couple of months (April??)
>>>>
>>>>You should definitely upgrade them to the production version of VFP9.0 which is available since December.
>>>>
>>>>HTH
Previous
Reply
Map
View

Click here to load this message in the networking platform