Solved

Record already locked by this session

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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

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…
In this tutorial I will show you how to use the Windows Speech API in Delphi. I will only cover basic functions such as text to speech and controlling the speed of the speech. SAPI Installation First you need to install the SAPI type library, th…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
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…

785 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