A useful resource is the Borland Developer Support site when dealing with
these issues
http://www.borland.com/devsupport/bde/ti_list/TI2993.html
Technical Information Document (TI2993)
Removing "Lock file has grown too large" Error
Product: BDE
Version: All
Platform: Windows 3.1, Windows 95, Windows NT
----------------------------------------------------------------------------
----
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:
The Executable is in the same directory as the table.
The Private Directory is not correctly set or not set at all.
Delphi: Having a TTable open on a paradox table and then performing multiple
TQuery operations.
C / C++: Having a table open with DbiOpenTable and then performing multiple
queries with DbiQExec and/or DbiQExecDirect.
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:
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.
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.
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.
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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Grant Black
> Sent: Wednesday, 2 June 1999 17:55
> To: Multiple recipients of list delphi
> Subject: [DUG]: Paradox - Lock file too big problem
>
>
> App written in D1 with Paradox tables (only about 5 small tables) on a
> ex-developers machine that may or may not have newer version of the BDE
> on it.
> �
> Users are getting 'Lock file too big" problem.� I haven't seen it yet
> and it is certainly not been seen on other machines.� The app is single
> user, installed on a single workstation.
> �
> Any ideas�on�where to�look?
> �
> The 32 bit replacement app is still months away so I am hoping its
> just�a setting or BDE conflict issue...
> �
> Grant Black
> Software Developer
> SmartMove (NZ) Ltd
> Phone:���� +64 9 361-0219 extn 719
> Fax� :���� +64 9 361-0211
> Email:���� [EMAIL PROTECTED]
> �
> ------------------------------------------------------------------
> ---------
> New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
>
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
