Hi,

I have a select where this statement return more one rows and i nedd lock this row, but i want not use for update, how can to do this activity.

Thank you.

Hi Georgipa,

Please test running SET ISOLATION TO REPEATABLE READ;
SELECT .......

Gustavo.

Hi,
You can give me an example for this activity, for example seudo code.

Than you for your help.

Hi,

Please test:

Begin work;
set isolation to repeatable read;
select * from anytable
where .....

This lock all read rows.

Gustavo.

Hi,

I test this statements in a session and other user login in other session and execute this same statements and no lock row.

thank you for you help.

Hi Georgipa,

The lock is put. Tried you to rewrite the row ??

Gustavo.

Hi,
In this case is fine, but I need execute
begin work;
set isilation to repeatable read;
select * from table1
where codigo_tabla = "XX";


and lock this rows thar return this select, whether other user execute

begin work;
set isilation to repeatable read;
select * from table1
where codigo_tabla = "XX"

in this case the program will be show a messge that rows is locked for other user.

Thank you.