Frequently Asked Questions
Table is full
Question:
Adding records to Paradox Table results in "Table is Full" error.
Answer:
Background:
Paradox tables all have a block size which is determined upon
creation by the Block Size entry in BDE Administrator. By default,
this value is 4K. Legal values for block size are 1K, 2K, 4K, 16K
and 32K. For block sizes greater than 4K the table level must be
set to 5 or higher. Paradox tables have a maximum number of blocks
of 64K. The maximum size of a table is determined by multiplying
the block size of the table times 64K (the maximum number of
blocks). For the default block size of 4K, this works out to 256
MB.
Solution:
To increase the block size of existing table there are two
alternatives. The simplest is to create a new table and move the
data from the old table to the table. More complex is to call
dbidorestructure. www.borland.com/devsupport/bde/files/pxrest.zip
has a Delphi example on how to do this. Note that just
restructuring a table to Database Desktop or Paradox for Windows,
or just changing the block size in BDE Admin is insufficient to
solve this problem.
LiveJournal
PhotoFile