At 10:59 AM 27-03-02 -0300, you wrote:

>When I change or I insert some records, and I run AppyUpdates, IBO records
>register them in the order inverse.
>
>Example:
>
>I insert record 1
>I insert record 2
>I insert record 3
>
>I run ApplyUpdates.
>
>IBO inserts record 3
>IBO inserts record 2
>IBO inserts record 1
>
>Because that?

Original dataset:

row 1
row 2
row 3 <--- cursor is here
row 4

Insert a row:

row 1
row 2
new row 1 <---- cursor is here
row 3
row 4

Insert another row:
row 1
row 2
new row 2 <--- cursor is here
new row 1
row 3
row 4

Insert another row:

row 1
row 2
new row 3 <--- cursor is here
new row 2
new row 1
row 3
row 4

When you ApplyUpdates, IBO goes through the cache starting at row 1, until
it finds the first inserted row - that is new row 3!

>How to solve? Already I looked the fontes more I did not manage to solve the
>problem.

Why is it a problem?

You could use Append...
Original dataset:

row 1
row 2
row 3 <--- cursor is here
row 4

Append a row:

row 1
row 2
row 3
row 4
new row 1 <---- cursor is here

Append another row:
row 1
row 2
row 3
row 4
new row 1
new row 2 <--- cursor is here
..and so on

cheers,
Helen

All for Open and Open for All
Firebird Open SQL Database · http://firebirdsql.org ·
http://users.tpg.com.au/helebor/
_______________________________________________________