Maximum Record Length

[clownchow]

Hi:

Been using foxbase 2.1X forever for some basic database operations to be compatible with some other legacy systems. I've run into a problem with the maximum record length being limited to 4000 characters. I probably need to double this. Could somebody tell me in what version does this limitation increase. Been reading the posts and I probably should do a major upgrade. I'm wondering, however, if I can just get away with upgrading to 2.6a.

Thanks!

 

[OnePunchMickey]

I'd just upgrade to Visual FoxPro 8.0 to be honest.

***************************************
Need help running those old FoxPro apps on modern systems?

http://www.hentzenwerke.com/catalogpricelists/painlesse.htm

 

[DSummZZZ]

2.5 through VFP 7 has this limitation:

Max. # of chars per record      65,000
Max. # of fields per record        255
Max. # of open DBFs                225
Max. # of chars per field          254

I don't have VFP 8 installed, but if you're going to upgrade, you should go to at least 7 or 8.
But if your records are getting that long, maybe it's time to rethink your design. Start splitting up tables.


-Dave S.-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm