Hi
More out of curiosity than anything else.

If I use vb6 with ADO to INSERT data into a MS SQL dbase, where does the data go...at the start, at the end, or at some cryptic spot in the middle?

I can successfully add data to the database, but if I do a SELECT * query, the most recent data is not at the start OR at the end of the RSet.

I know the data is there as I can find it using WHERE statements, and the total number of records grows correctly, as well.

I have not set, via VB or SQL statement or MSSQL itself, any sort of sorting method.
It is just a flat file db at present.
I have not implemented and keys or index....yet.

Does it just add the data anywhere it likes ?
Or does the recordset return data in no particular order in relation to the db, unless its sorted?

I was a bit confused by this.

Thanks.
Josh