Solved

Paradox Tables & PDOXUSRS.LCK file

Posted on 1998-02-12
4
1,799 Views
Last Modified: 2012-08-13
(Paradox is set to run in network mode)

When I run two SQLs Back to Back on a paradox table, PDOXUSRS.LCK file gets created!  The problem is if I run these two sqls over and over the PDOXUSRS.LCK keeps growing and growing.  BUT if I only run one SQL over and over, the PDOXUSRS.LCK does not grow. Why is this PDOXUSRS.LCK growing when two sqls run back to back multiple times.  The other problem is that because the file keeps growing.  This file reaches 25 MEGS. and it busts.  Errors start appearing!

These queries are simple select queries.  
(Select * from xxx where TDdate > 1/15/95 )
0
Comment
Question by:phil_caetano
  • 2
4 Comments
 
LVL 1

Expert Comment

by:zac
ID: 1359086
Phil,

Are these queries simple select queries, or are the insert / update / delete queries?  Or does this make difference to rate at which the LCK file grows?

Zac
0
 

Author Comment

by:phil_caetano
ID: 1359087
Edited text of question
0
 
LVL 1

Expert Comment

by:RJENKINS
ID: 1359088
From Borland TI 2993

... Snip

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.

Hope this helps.
RCJ

0
 
LVL 1

Accepted Solution

by:
RJENKINS earned 100 total points
ID: 1359089
As Above
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Introduction Raise your hands if you were as upset with FireMonkey as I was when I discovered that there was no TListview.  I use TListView in almost all of my applications I've written, and I was not going to compromise by resorting to TStringGrid…
In my programming career I have only very rarely run into situations where operator overloading would be of any use in my work.  Normally those situations involved math with either overly large numbers (hundreds of thousands of digits or accuracy re…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now