Does anyone know how many records can be stored in a Paradox table?

I have a query that is retrieving data from an Oracle table and am getting "Table is Full" error.

The query is returning a total of 494,721 records.

pbare

The available RAM determines the size of your table and it is not dependent on the number of records but on the total amount of data.

"Incorrect." The amount of RAM actually has nothing at all to do with it.

A Paradox table consists of up to 65,535 "blocks" of some multiple of 2K per block, with an integral number of records per block. The block-size is probably much too small. With 494,000-odd records, I'm sure of it.

Block-sizes are changed by editing the BDE Configuration parameter, exiting and restarting Paradox, then constructing a new table with the same structure as the old. The Borland web-site at http://www.borland.com/devsupport/bde has a utility to do it.

Index files are also "Paradox tables," and a "table is full" usually when any index to that table is full.

Thanks Sundial,

I have been using paradox for years (more than we want to count) and I do believe that version 4.5 (back when they had dos versions as well) had the Ram limit. But you are correct and forced me to review the current specs.

Thanks

No problem. We all indulge in improper slices of beef ("mis-steaks") ...

("Oops!", he said, quickly strapping on his tomato-proof bunny suit...)