Subject | A question about "with lock" |
---|---|
Author | ibrahim bulut |
Post date | 2005-03-02T08:30:51Z |
Hi all,
i have a question about with lock clause and triggers
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
how firebird server lock this records
ibrahim Bulut
ileti�im Online Ltd.�ti.
Software and Database Expert
Turkish Republic
[Non-text portions of this message have been removed]
i have a question about with lock clause and triggers
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
how firebird server lock this records
ibrahim Bulut
ileti�im Online Ltd.�ti.
Software and Database Expert
Turkish Republic
[Non-text portions of this message have been removed]