I need to be able to detect if a specific record contain in a database is
currently locked or if i actually can write in it

What i want to do is to hold modifications unto a record that is locked by
another user until it unlock and became accessible again..

Is there a property like TTable.RecordLocked or something like that??

Thanks,
 Mike

In article <oHeR5.1260$Bm.16...@news.globetrotter.net>, "Michel Hudon"

No, but there is a BDE API call - dbiIsRecordLocked. BDE API Help might give
you sufficient detail, or you might need some example code, which is not in my
skills at this time <g>

Alan Lloyd
alangll...@aol.com

news:oHeR5.1260$Bm.16917@news.globetrotter.net...

If you don't want to use a direct BDE call you can use a try/except block:

try
    aTable.Edit
except
    on e : eDBEngineError do ShowMessage (e.Message);
    end;
if aTable.State = dsEdit
then // record isn't locked

: In article <oHeR5.1260$Bm.16...@news.globetrotter.net>, "Michel Hudon"
: >Is there a property like TTable.RecordLocked or something like that??

: No, but there is a BDE API call - dbiIsRecordLocked. BDE API Help might give
: you sufficient detail, or you might need some example code, which is not in my
: skills at this time <g>

It's not something I've coded either, but I know there is sample code
for all the BDE APIs at Borland's website.  They've been moving the
pages around; the old location was http://www.borland.com/devsupport/bde/delphi/
--
Rick Carter
carte...@email.uc.edu