[DUG]: Locking Records

2000-12-14 Thread Sandeep
Hi How do I lock a record before TIBTable goes into edit mode. Sandeep --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to:

Re: [DUG]: Locking Records

2000-12-14 Thread Neven MacEwan
resolution on updates (which is what you have to do in SQL because you cannot "lock" records) HTH Neven - Original Message - From: Sandeep [EMAIL PROTECTED] To: Multiple recipients of list delphi [EMAIL PROTECTED] Sent: Friday, 15 December 2000 12:49 Subject: [DUG]: Locking Records

Re: [DUG]: Locking Records

2000-12-14 Thread Sandeep
On 15 Dec 2000, at 13:03, Neven MacEwan wrote: Sandeep You don't, SQL Servers have no exposed concept of a lock If you want the easiest port from an ISAM to SQL I'd recommend you use ADOExpress (tho i've never used it with IB). ADO would give you your filters and locates and then the

RE: [DUG]: Locking Records

2000-12-14 Thread Paul Ritchie
of list delphi Subject: Re: [DUG]: Locking Records On 15 Dec 2000, at 13:03, Neven MacEwan wrote: Sandeep You don't, SQL Servers have no exposed concept of a lock If you want the easiest port from an ISAM to SQL I'd recommend you use ADOExpress (tho i've never used it with IB). ADO

Re: [DUG]: Locking Records

2000-12-14 Thread Neven MacEwan
Sandeep It is possible to lock a record using FIB TDataset. Table.LockRecord is used to lock a record. When the LockRecord function is called an update query is executed. And what does this 'update query' do? All I was stating was that SQL does not expose the concept of record locking

RE: [DUG]: Locking Records

2000-12-14 Thread Myles Penlington
of list delphi Subject: Re: [DUG]: Locking Records Sandeep It is possible to lock a record using FIB TDataset. Table.LockRecord is used to lock a record. When the LockRecord function is called an update query is executed. And what does this 'update query' do? All I was stating