Board index » off-topic » Paradox 7 Table full after only 589816 records

Paradox 7 Table full after only 589816 records


2003-08-07 02:26:52 AM
off-topic15
Hi,
I'am using a Paradox 7 Table in an Delphi5/BDE Project.
After only 589816 records I receive an DBIERR_TABLEFULL error during
appending/inserting new records.
Paradox7 claims to be able to handle more than 2 billion records.....
The Borland Database Desktop reports the same error-message. Seems
to be a BDE problem.
Here are some informations:
- Paradox 7
- table password
- small records (14 fields I,D or A30)
- Autoinc-field (+) as primary key
- 2 secondary indices (D and A30 fields)
This table has actually 589816 records and works fine. The TTable.Post
after an TTable.Append raises the Exception.
Thanks a lot
Stefan Kopf
( XXXX@XXXXX.COM )
 
 

Re:Paradox 7 Table full after only 589816 records

Stefan Kopf wrote:
Quote
file.db 134,217,728
you've got the minimum block size on that table.. 2k blocks.. 128 meg
max table size.. increase the block size.. 4k, 8k, or 32k blocks..
usually, the way to do that is to make a new table with the new block
size, and pass the data to the new table..
Steve Green - Diamond Software Group, Inc - Waldorf Maryland USA
Corel CTech Paradox - www.diamondsg.com - Support/Downloads/Links
---------------------------------------------------------------------------------
Do you need a Sanity Check? www.diamondsg.com/sanity.htm
Upgrade/Downgrade versions? www.diamondsg.com/upgrade.htm
-------------------------------------------------------------------------
 

Re:Paradox 7 Table full after only 589816 records

What is the size of the Block Size in BDE Administrator ?
What is the Level ?
Use the tools to verify tables :
www.bdesupport.com/tools.htm
you should consult :
www.bdesupport.com/resources.htm
www.bdesupport.com/samples/bdespecs.htm
Jean-Michel
"Stefan Kopf" < XXXX@XXXXX.COM >a écrit dans le message de
Quote
Hi,

I'am using a Paradox 7 Table in an Delphi5/BDE Project.
After only 589816 records I receive an DBIERR_TABLEFULL error during
appending/inserting new records.
Paradox7 claims to be able to handle more than 2 billion records.....
The Borland Database Desktop reports the same error-message. Seems
to be a BDE problem.

Here are some informations:
- Paradox 7
- table password
- small records (14 fields I,D or A30)
- Autoinc-field (+) as primary key
- 2 secondary indices (D and A30 fields)

This table has actually 589816 records and works fine. The TTable.Post
after an TTable.Append raises the Exception.

Thanks a lot

Stefan Kopf
( XXXX@XXXXX.COM )
 

{smallsort}