Subject | FOR UPDATE clause |
---|---|
Author | Marcos Vinicius Dufloth |
Post date | 2001-08-15T18:46:03Z |
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.
TIA.
Dufloth.
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.
TIA.
Dufloth.