Solved

Paradox Tables & PDOXUSRS.LCK file

Posted on 1998-02-12
4
1,825 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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

The uses clause is one of those things that just tends to grow and grow. Most of the time this is in the main form, as it's from this form that all others are called. If you have a big application (including many forms), the uses clause in the in…
Introduction I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need. This article will address some of the concepts when dealing with a multithreaded delphi database…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

792 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