from TI :
Article #15256: Removing "Lock file has grown too large" Error
Technical Information Database
TI256B.txt Removing "Lock file has grown too large" Error
Category :General Programming
Platform :All
Product :BDE All
Description:
Lock file has grown too large, Decimal:9495 Hex:2517
----------------------------------------------------
This problem is specific to Paradox tables and can be caused
in any BDE (16 or 32 Bit) application that meet some or all
of the following criteria:
1) The Executable is in the same directory as the table.
2) The Private Directory is not correctly set or not set
at all.
3a) Delphi: Having a TTable open on a paradox table and
then performing multiple TQuery operations.
3b) C / C++: Having a table open with DbiOpenTable and
then performing multiple queries with DbiQExec and/or
DbiQExecDirect.
4) LOCAL SHARE set to true in the BDE Configuration
Utility on the System page.
To solve the problem, make sure that your application has
done ALL of the following:
1) Under the directory where the executable is, create
three new directories: TABLES, PRIV, and NET. Place
all the tables for the application into the TABLES
directory.
2) Set the session's private directory to the PRIV
directory. Take the following steps according to
the software you are using.
DELPHI:
Session.PrivateDir := ExtractFilePath(ParamStr(0)) + 'PRIV';
C / C++:
DbiSetPrivateDir(szPath);
// szPath is the fully qualified path (not relative)
// to the PRIV directory.
3) Set the session's network directory to the NET
directory. Take the following steps according to
the software you are using.
DELPHI:
Session.NetFileDir := ExtractFilePath(ParamStr(0)) + 'NET';
C / C++:
DbiSetProp(hSes, sesNETFILE, (UINT32)szPath);
// szPath is the fully qualified path (not relative)
// to the NET directory.
// hSes is the current session handle. This can be
// retrieved using the DBiGetCurrSession function.
4) If LOCAL SHARE is set to true and you are not sharing
tables between different applications at the same time,
change LOCAL SHARE to false.
The above steps will correct the Lock File Too Large error.
-----Original Message-----
From: Mark Howard [mailto:[EMAIL PROTECTED]]
Sent: Friday, 6 October 2000 07:13
To: Multiple recipients of list delphi
Subject: [DUG]: Lock File too big
Hello
D5 / Paradox
I am having problems at 2 sites when they run a quite complex (I think) QR
report.
The symptoms at both sites are not exactly the same and I can't re-produce
them on my development system. At one site QR will not preview but will
print, but then the format of the report bombs seriously after 10 pages of a
44 page report. (a landscape report turns to portrait with other stuff
happening too). I think there is something wrong with the design of the
Query too - it is taking an hour forty five to run.
A clue turned up at one of the sites with an error message saying "Lock file
too big" when they last tried to run this report. This is a single user
site.
The report accesses 5 tables only using 5 TQuery's. Can anyone tell me
under what circumstances one would expect to get that error message? Any
other suggestions would be gratefully received.
The code containing the TQuery's is about 70 lines - is it OK to post that
amount of code to the list?
Mark
CAUTION - This message may contain privileged and confidential information intended
only for the
use of the addressee(s) named above. If you are not the intended recipient of this
message you are
hereby notified that any use, dissemination, distribution or reproduction of this
message is prohibited.
If you have received this message in error please notify Progressive Enterprises Ltd.
immediately via
email at [EMAIL PROTECTED] Any views expressed in this message
are those of the
individual sender and may not necessarily reflect the views of Progressive Enterprises
Ltd.
This footnote also confirms that Progressive Enterprises Ltd. has swept this email
message for the
presence of computer viruses. This does not guarantee this message is virus free.
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
