Record has been locked by another user

[ziller]

Here is my query :

select id.rowid,id.cod_ind,id.cod_doc,id.eta_doc,nvl(id.lib_doc,d.lib_doc) "LIB_DOC",
id.cmt_doc,id.dat_cre_doc,id.dat_mod_doc
from insw.iw_ind_doc id,insw.iw_doc d
where id.cod_ind = :cod_ind
and d.cod_doc = id.cod_doc
order by id.cod_doc

it returns 2 rows.

i can modify the 2nd row but when i try to modify the 1st i have the message 'Record has been locked by another user'.
But i'm the only one user...

any idea?

 

[Marco Kalter]

Are you sure the message is not "Record has been changed by another user" (instead of locked)? This can by caused by the NVL expression that has an alias with the same name as the original column. If LIB_DOC is NULL, it will appear to the dataset that the record is changed. You should use a different name for the alias.

------------------
Marco Kalter
Allround Automations

 

[ziller]

you're right, sorry...

i will test it and keep you informed.

thanks!

 

[ziller]

Great! it works now!

thank you very much.