Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Record already locked by this session

Posted on 2004-10-18
2
Medium Priority
?
448 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 500 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 500 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

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…
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…
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…

916 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