<< what is the truth?>>

Be careful! That's what Pontius Pilate asked just prior to making a very
poor decision.

Clay Shannon,
Dimension 4 Software

-----Original Message-----
From: ibrahim bulut [mailto:i.bulut@...]
Sent: Wednesday, March 02, 2005 9:53 AM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] A question about "with lock"



Hi Ivan
i understand your answer.
but Helen's answer is different from your answer.
Helen said "This form of pessimistic locking does not affect your triggers"

please check the mail archive.

thanks

----- Original Message -----
From: "Ivan Prenosil" <Ivan.Prenosil@...>
To: <firebird-support@yahoogroups.com>
Sent: Wednesday, March 02, 2005 2:41 PM
Subject: Re: [firebird-support] A question about "with lock"


>
>> if i read records with "with lock" clause, if there are before/update
>> triggers for table, are they fire
>>
>> i read the record like this
>>
>> select * from table
>> where id = 5 with lock
>>
>> and there is an before update trigger of this table
>> and there is an after update trigger of this table
>>
>> are theese triggers is fire with lock clause
>
> No triggers will be fired. "with lock" was introduced to:
> * allow locking of records without firing triggers
> (otherwise dummy update would be sufficient)
> * lock row and read its contents in one operation
>
>> how firebird server lock this records
>
> The same way as dummy update, except that triggers
> will not fire.
>
> Ivan
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>




Yahoo! Groups Links