🚀 go-pugleaf

Your suggestion is basically the approach I have taken. I was just wondering
if there was an "elegant" solution based on the data set itself. Though, now
there appears as though there isn't unless I were to subclass TClientDataSet
or something to perform such rearranging behavior.

Cheers!


"Mark Cashman" <mcashman@temporaldoorway.com> wrote in message
news:3ACBA6CC.A514FC7F@temporaldoorway.com...
> Hi!
>
> Recno means nothing to most DBMS which, for a variety of reasons may or
> may not store records in any sort of "real" order (hash tables, for
> instance have no real order).
>
> Indexes give a view of the same records in the order the index decrees,
> and each index has a different "order". In addition, in a real
> client-server database, a single insertion could force recounting and
> renumbering of a potentially prohibitive number of records.
>
> To create a sequenced table you will need to have a sequence number
> field and you will need to manage resequencing. It is a moderately
> complex problem, but it can be done.
>
> ------
> Mark Cashman (TeamB - C++ Builder), creator of The Temporal Doorway at
> http://www.temporaldoorway.com
> - Original digital art, writing, music and more -
> C++ Builder / JBuilder Tips and The C++ Builder Programmer's Webring
> (Join us!)
> http://www.temporaldoorway.com/programming/index.htm
> ------
>
>