ckrudelux Posted October 1, 2010 Share Posted October 1, 2010 Don't know how this happened! First 3 records are fine after them the newest record is added and older records after it.Record 1:Record 2:Record 3:Record 6:Record 5:Record 4:If I would add a record it would be added over record 6 Link to comment Share on other sites More sharing options...
trevelluk Posted October 1, 2010 Share Posted October 1, 2010 If you mean, the records are not stored in primary key order, that's entirely possible. The SQL standards, IIRC, give absolutely no guarantees as to the order in which data will be stored.You should use an ORDER BY clause in your SELECT query if you need to make sure the records are displayed in the correct order. Link to comment Share on other sites More sharing options...
ckrudelux Posted October 1, 2010 Author Share Posted October 1, 2010 If you mean, the records are not stored in primary key order, that's entirely possible. The SQL standards, IIRC, give absolutely no guarantees as to the order in which data will be stored.You should use an ORDER BY clause in your SELECT query if you need to make sure the records are displayed in the correct order.I know how to get the data out right I was just so surprised by how the records are stored.. felt like I had done something to make it store the data like what. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.