Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Paradox Tables & PDOXUSRS.LCK file

Posted on 1998-02-12
4
Medium Priority
?
1,860 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 400 total points
ID: 1359089
As Above
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

Introduction The parallel port is a very commonly known port, it was widely used to connect a printer to the PC, if you look at the back of your computer, for those who don't have newer computers, there will be a port with 25 pins and a small print…
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…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
Suggested Courses

688 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