One of our apps opens some 30 tables when it starts. Sometimes
only two tables open, on other occasions all the tables open. it even
happens that no tables open !
Sometimes the computer hangs.
Funny though, there is no pattern. I'm not looking for a solution !
I just would like to know whether someone else has experienced
these things. Specially when there is no pattern I'm feeling
like Fox Mulder...

Markku Nevalainen heeft geschreven in bericht <36992441.7...@iki.fi>...

I usually keep all my tables closed when the app starts, and in
FormCreate or FormShow event open only those tables that are needed.
When I Close the form, I usually also first close the tables.

If I would need to debug the Table openings, I could easily put
IDE de{*word*81} break points to all those Table.Open lines, and watch what
is there actually happening.

If I were desperate, and had to test with compiled EXE at the customer's
site, I probably would make some kind of special test Form. Put a Label
for each Table on the form, and change these captions on every Table
opening/closing. Or maybe use DataSource's OnStateChange -event to
change those test Labels. (Phew, I have newer been that desperate yet)

My greetings to Scully:)

DataModule1.create;
Log('DataModule1 was created'); --> is written to log-table
Bar.stepit;
DataModule2.create;
Log('DataModule2 was created');
Bar.stepit;
Table1.open;
Log('Table1 opened');
Bar.stepit;
etc.

This way you can forget about opening tables during execution

But sometimes the Win95-machine hangs between steps (and
not always at the same spot) ?

What exactly does 'Paradox behaves unreliable' mean? You're not
giving any information we can use to help...

Ken
--
Ken White

Clipper Functions for Delphi
http://members.aol.com/clipfunc

Kees

You should find postings saying "I have problems with Paradox...Heeeelp me".
And also those who say they have built multi user apps, having hundreds of
megabytes BDE/Paradox tables with no significant problems.

I had a small table repair utility that scanned multiple directories for
db's to checkout, and until KeepConnections was set false, 25 was the most
tables that would open!! (in other words, if all your tables are in the same
dir, this may not help).

BTW: make sure that your tables are not in the same dir as your app!

You haven't provided any information with which to even consider
coming up with an answer. And I've been working with Delphi since
1.0 was initially released; your comment about my not being able
to give suggestions is rude.

If you want to actually provide a question with at least basic
information, I'll be glad to try and help. If you want to continue
being vague and rude, I withdraw the offer.

Ken
--
Ken White