Re: SQL record locking ?

Article View: borland.public.vdbase.data.sql

Article #1564

Back to borland.public.vdbase.data.sql Previous Next

#1564

From: Bowen Moursund
Date: Tue, 09 Dec 1997 00:00

16 lines
1063 bytes

>I'm new to SQL, and I haven't seen any reference to record locking. How
>can I achieve record locking and how would I verify that a record is
>locked before use ?

Do you mean local SQL, i.e. SQL on native tables? Record locking works the
same as with the dBASE DML.

If you're talking about SQL to a server DBMS, it depends upon the DBMS. Some
support active locking via the BDE, some do not. Typically you should use
transaction processing with a server DBMS, and let the DBMS handle the
locking.
__
Bowen Moursund (TeamB)
bowen.NOSPAM@nerds.com
http://www.mindspring.com/~bowenm/datatech.htm

Technical Details

Message-ID: <66jv9e$oe6@forums.borland.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <348D4B0C.54FBEF60@map.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,c789209d8d0d9096
X-Google-Attributes: gidff5a1,public
From: "Bowen Moursund" <teamb@opto-pps.com>
Subject: Re: SQL record locking ?
Date: 1997/12/09
Message-ID: <66jv9e$oe6@forums.borland.com>
X-Deja-AN: 296656861
References: <348D4B0C.54FBEF60@map.com>
X-MimeOLE: Produced By Microsoft MimeOLE V4.71.1712.3
Organization: DataTech
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message