Subject FOR UPDATE clause
Author Marcos Vinicius Dufloth
Please, could somebody light me about this? In Oracle, "select .. for
update" lock the rows affecteds until commit/rollback. Browsing IB docs I
read that "for update" is used only with "declare cursor .. " to especify
subsequent "update .. where current of". Whell, the Oracle behavior (and MS
SQL Server too) isn't the right (ANSI SQL) implementation? Could Interbase
implentation is same like this but don't documented? If not (implemented)
then I will suggest it.