Solved

Record already locked by this session

Posted on 2004-10-18
2
439 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
[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 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Creating an auto free TStringList The TStringList is a basic and frequently used object in Delphi. On many occasions, you may want to create a temporary list, process some items in the list and be done with the list. In such cases, you have to…
Introduction Raise your hands if you were as upset with FireMonkey as I was when I discovered that there was no TListview.  I use TListView in almost all of my applications I've written, and I was not going to compromise by resorting to TStringGrid…
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
Suggested Courses
Course of the Month7 days, 8 hours left to enroll

632 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