Board index » delphi » PDOX - table create problem.

PDOX - table create problem.

Hi troops,

I'm using Delphi 3.02/BDE 4.51 & have approx 370 paradox
tables (*.DB). These tables range in version from V4 - V7.
Upgraded where needed.

Problem:

I have finally got the code for creating tables + related indexes
+ referential integrity rules. Got this off Inprise BDE sample code
site.

The code is there so when I install at a new customer site, the
program detects no tables and creates them all for me. Sounds great
in theory.

When I run the code, BDE chugs away, and creates mainly 80-85%
of the table structures. Some tables miss the *.DB, others the *.VAL.
I then think must be the moons in a bad spot, so I'll delete all the
creations and start over -> this time I get other missing tables etc.

Basically no 2 times yield the same results.

Is there something special I have to do when doing this?

Has anyone else had this sort of thing happen?? Really bizzar.

Millions of thanks for any help on this one,

Cheers,

Mick Badran

 

Re:PDOX - table create problem.


Quote
> I'm using Delphi 3.02/BDE 4.51 & have approx 370 paradox
> tables (*.DB). These tables range in version from V4 - V7.
> Upgraded where needed.

> The code is there so when I install at a new customer site, the
> program detects no tables and creates them all for me. Sounds great
> in theory.

> When I run the code, BDE chugs away, and creates mainly 80-85%
> of the table structures. Some tables miss the *.DB, others the *.VAL.

A wild thought:  Win 95 allows only 250 files open at any one time (that
includes all the files that Windows needs for itself, so you are left
with less than that for your application).  I don't know how your
program loops and creates the tables but it could have something to do.
Just in case, ensure that you create one table and its associated
*.VAL, *.R, *.F, *.Y tables at a time and then close/release them before
starting with the other.  Or try your installation with 100 tables
first!  If your application really needs a whole bunch of tables open at
a time you'll find this problem over and over again.

Good luck.

Other Threads