Hi,

If you don't use an ORDER BY clause, the result-set is un-ordered.

Or at least, the ordering in unspecified and implementation and
situation (query-plan etc) dependent.

So, if you want your result-set ordered, use an ORDER BY clause.

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."

> Hi
>
> I have e table in which I have inserted a lots of records.
> Sometimes I have to access some of them in the exact order they were
> inserted in.
>
> If I just do a "select * from Table where MyField=:PMyField" can I
> then be sure that the fields returned to me are in the exact same
> order as they were inserted in ?
>
> I have done some test, and it seems this way, but I would like to be
> sure.
>
>
> Of course I could put on a Autoincrement field to solve my problem,
> but I havn't one now, and would like to solve my problem without
> doing this.