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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only