>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.
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05