Friedrich wrote,

>How can I make sure, that the sequence of records stored in a TI detail
dataset, corresponds to the >time, when they are entered?
>
> I do not want TI to reuse the space of a deleted record, but to add the
new entry at the end of the set.
It depends on the definition of the word 'sure' and what you intent is.

If the intent is for performance reasons you do not want the disk IO
associated with reusing a deleted record then simply enable the HWMPUT
feature in DBUTIL, or better yet programmatically by:

* THIS TURNS ON HWMPUT DYNAMICALLY!
CALL "DBCONTROL" USING DBNAME, DBDUMMY, MODE9, DBSTATUS.

If the intent is to be 100% 'sure' that DBGET returns the records in the
exact sequence that they were originally added then you have to add a time
date stamp or a sequence counter. I prefer to read and sort on this field
over specifying it as a sort item on a path. But this choice is highly
application dependent.

Even if entries are originally added at the High water mark it is very risky
to rely on this sequence for mode 2 DBGET for future sequential retrieval.
Other applications may be added later that are intended to 'fix up' fields
that DBDELETE & DBPUT entries.

Mike Hornsby
Beechglen Development Inc.
Enterprise Solutions & Support
www.beechglen.com
513-922-0509