Solved

Record already locked by this session

Posted on 2004-10-18
2
432 Views
Last Modified: 2010-05-18
Hi :)

I've posted a question a while ago about an error I was getting.  The error is "record already locked by this session" and occurs when I try to put a TTable in edit mode.  Here is a link to the previous question:  http://www.experts-exchange.com/Programming/Programming_Languages/Delphi/Q_21071319.html


People told me that the problem probably occured because of locked blocks within the dataset.  I quickly solved the problem by doing a close/open after each post.  This worked ok for a while but now I can't use this solution due to the fact that it is too slow for my application.

So here is my question again:  how can I get rid of the error "record already locked by this session".

Thanks :)
0
Comment
Question by:qas
2 Comments
 

Accepted Solution

by:
MPountley earned 125 total points
ID: 12367063
The Accepted Answer from your last post is not correct. I worked for the BDE for ... too many years.

Is it possible that your BDE install is corrupt?
Have you tried this on another PC?

Also, are you using a TDatabase component? You really should be.

Editing with TQueries and RequestLive Property is a much safter, more reliable and flexible option with BDE and Paradox tables.

You should ensure that you do not have multiple instances of your TTable, or the form/Data Module that holds the TTable.

Regards,
Mark
0
 

Assisted Solution

by:sdrdb
sdrdb earned 125 total points
ID: 12378900
I had the same problem with a production program with a paradox table that held many pictures.  The close/open trick worked for awile untill the database got large and the system slowed down to a crawl.

The way out I found was to replace the ttables with tquery components.  It makes for alot of work, but made the program 100 times faster.  

Changing this will also help if and when you eventually convert to a different database plateform.  

0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

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…
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…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

820 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