Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
FPT file 2GB Limit? A final answer?
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00562711
Message ID:
00563071
Views:
22
>Did you tried "PACK" command over your table? This command not only remove records marked for deletion, but also allows to pach the FPT file content by removing gaps (unused space) in it. There is and option "MEMO" that allows you to run PACK without touching of records marked for deletion )if you use them in production).

Hi Vlad,

This error occured as I was appending records from an FP2.5 table to a VFP7 table during a conversion/upgrade. The error occured around record 2600 of over 50,000 so even if I pack the memo file I dont think I can stay within the 2MB limit. I was hoping there was a 'set' command or something to get around this limitation.

Instead I am going to try to store the data as character records in a table, copy them into an edit box for editing, then strip out carriage returns etc. and save each line as a record back to the table.

I tried to find something that does this in the 'download' section of the UT but was unable.

Thanks for you help.
The day you take complete responsibly for yourself, the day you stop making any excuses, thats the day you start to the top. - O.J. Simpson

Great advice from a questionable source...
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform