I need to make some batch updates in multiple tables, but have the following problem : when inserting, only the last record is indexed properly.

The code looks like that:

***
begin transaction
...
insert into (Table_1) ...
...
replace ... in (Table_2)
...
insert into (Table_3) ...
insert into (Table_3) ...
insert into (Table_3) ...
...
if ...
end transaction
else
rollback
endif
***

Note: all tables are locked properly, no table/record buffering is used

Problem: after "end transaction" all changes are made to DBF files, but only the last inserted record appears in corresponding CDX file.

Please help me if you know how to solve this problem. Thanks.

Any related comments or ideas are welcomed too.