?
Solved

Paradox Tables & PDOXUSRS.LCK file

Posted on 1998-02-12
4
Medium Priority
?
1,872 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 400 total points
ID: 1359089
As Above
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Objective: - This article will help user in how to convert their numeric value become words. How to use 1. You can copy this code in your Unit as function 2. than you can perform your function by type this code The Code   (CODE) The Im…
Have you ever had your Delphi form/application just hanging while waiting for data to load? This is the article to read if you want to learn some things about adding threads for data loading in the background. First, I'll setup a general applica…
Loops Section Overview
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?
Suggested Courses
Course of the Month14 days, 5 hours left to enroll

809 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