Hi Christian,

thanks for that - I figured I'd be wrong somehow !

Cheers,
Norman.

-------------------------------------
Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar@...
Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com
-------------------------------------


-----Original Message-----
From: Christian Gütter [mailto:cguetter@...]
Sent: Monday, December 09, 2002 3:18 PM
To: IBObjects@yahoogroups.com
Subject: Re: [IBO] For UPDATE clause?


Hi Alan and Norman,

> Basically, this command allows you to make sure that all the
> rows you wish
> to update are available and unlocked. I'm sure that if
> Firebrid does it
> differently, I'll be corrected :o)

AFAIK, there is no row locking when you execute
a "SELECT FOR UPDATE" in IB and FB. They both do
some kind of "optimistic locking". This is also
why you have to do a dummy update to lock a row.

This email is intended only for the use of the addressees named above and
may be confidential or legally privileged. If you are not an addressee you
must not read it and must not use any information contained in it, nor copy
it, nor inform any person other than Lynx Financial Systems or the
addressees of its existence or contents. If you have received this email
and are not a named addressee, please delete it and notify the Lynx
Financial Systems IT Department on 0113 2892990.