Subject | Order of inserts |
---|---|
Author | mivi71dk |
Post date | 2002-08-09T12:07:07Z |
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.
Regards
Michael
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.
Regards
Michael