Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 450
  • Last Modified:

Record already locked by this session

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
qas
Asked:
qas
2 Solutions
 
MPountleyCommented:
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
 
sdrdbCommented:
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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now