[marcoszorrilla]

Table is Full with Paradox Tables - by Borland Developer Support Staff

Abstract:Increasing block size allow tables to be larger

Question:
I am attempting to add data to my Paradox table but I'm getting the Error "Table is Full". What is the cause of this and
how can I add more records?

Answer:
Paradox tables have a block size which determines the maximum record size for a table and the table's maximum
size. By default tables have a block size of 4K. Regardless of the block size, tables can have a maximum of 64K
blocks. This means by default a table can grow to 256 MB.

You can increase the block size of a table in 1 of two ways.

1.Run BDE Admin and change the block size for the Paradox driver to a revised number. Legal block sizes are
1024, 2048, 4096, 16384 and 32768. If your block size is larger then 4096 then you must also change level to be
at least 5. Finally, create a new table and batchmove your data from your old table to your new table
2.It is possible to change the block size of an existing table by calling dbiDoRestucture. For an example see
www.borland.com/devsupport/bde/files/pxrest.zip

Un Saludo.