I don't believe relational databases preserve any order of records in
loading data. If you want a specific order, then you have to "order by"
the appropriate data columns in retrieval.
Richard G
Henning wrote:
>
> Does anyone know how I can prevent Allbase from dis-sorting my
> sorted data when loading from a flat-file ??
>
> It seems to me there is some sort of wraparound which causes the
> disorder. When I load just a few data, the sorting-order is
> intact but as soon as I load a huge amount of data, the sorting-
> order gets lost somewhere during loading. Is it a matter of
> table-size ?
>
> tia,
>
> Henning
--
Richard Gambrell
Database Administrator and Consultant to Computing Services at
** UTC business:
University of Tennessee at Chattanooga
113 Hunter Hall, Dept. 4454
615 McCallie Ave., Chattanooga, TN 37403-2598
fax: 423-755-4025
phone: 423-755-4551 email: [log in to unmask]
** other business or private:
voice mail/phone: 423-874-0261 email: [log in to unmask]