Board index » delphi » Paradox - Table Full - ???

Paradox - Table Full - ???

I am getting a 'Table Full' error (statement) in a Paradox Table.

Here is what the table looks like:

Field Name     Type     Size     Keyed
---------------------------------------------------------
Field1             D                       *
Field2             A          8           *
Field3             A          8           *
Field4             A         15          *
Field5             T        
Field6             A          8
Field7             I          8
Field8             I          8
Field9             A         100          

The total number of records is 713,360 and is 131,07KB.  The .PX file is
3298KB.

The first 4 fields make up a unique key and are thus keyed together. Other
then that the table is pretty ordinary.  Is there a limit to the number of
records in a Paradox table.  Being 32bit, I would have though it would have
had logical address (theoretical, not practical) space into the 4 billion
range.

Any help on this would be greatly appreciated.

Thanks,

Adam R. Aitken
eAds

ait...@teleteam.net

 

Re:Paradox - Table Full - ???


 Adam R. Aitken wrote in article <5iu1q7$...@brutus.teleteam.net>...

Quote
>I am getting a 'Table Full' error (statement) in a Paradox Table.

> .... snip
>The total number of records is 713,360 and is 131,07KB.  The .PX file is
>3298KB.

Change the BLOCK SIZE for the PARADOX Driver in the BDE Configuration
utility.  You'll need to recreate the table.

Paul

Re:Paradox - Table Full - ???


pag...@onramp.net (Adam R. Aitken) wrote:

  >I am getting a 'Table Full' error (statement) in a Paradox Table.
  >
  >Here is what the table looks like:
  >
  >Field Name     Type     Size     Keyed
  >---------------------------------------------------------
  >Field1             D                       *
  >Field2             A          8           *
  >Field3             A          8           *
  >Field4             A         15          *
  >Field5             T        =20
  >Field6             A          8
  >Field7             I          8
  >Field8             I          8
  >Field9             A         100          =20
  >
  >The total number of records is 713,360 and is 131,07KB.  The .PX file =
is=20
  >3298KB.
  >
  >The first 4 fields make up a unique key and are thus keyed together. =
Other=20
  >then that the table is pretty ordinary.  Is there a limit to the =
number of=20
  >records in a Paradox table.  Being 32bit, I would have though it would=
 have
  >had logical address (theoretical, not practical) space into the 4 =
billion=20
  >range.
  >
  >Any help on this would be greatly appreciated.
  >
You need to adjust the block size in the BdeConfig. This basically
decides how large youre tables can be.

--------------------------------------
Paul Sjoerdsma
Managing Director
Straight Line Solutions Co. Ltd.
Bangkok-Chiang Rai, Thailand
email: pa...@loxinfo.co.th
http://www.loxinfo.co.th/~paulg/

Other Threads