Subject A question about "with lock"
Author ibrahim bulut
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]