> >>I don't think that is something that would come up in for
> >>many of us. Since there is NO natural order in a relational
> >>database, the order is always controlled by an index.
> >
> > Order is always controlled by an ORDER BY - I assume you
> > wanted to say that...
>
> No but you are right. The point I was trying to make is that
> the order of records 'stored' in the database is not
> necessarily the same as the 'natural' order they are loaded,
> so some means of controlling the order - other than 'as
> loaded' - is always required, for a consistant view.
>
> And even that does not sound quite right ;)

Well, at least it sounds like we're both on the same track :)

(babbling about - that is... :)

--

With regards,

Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions
http://www.upscene.com