MaarX Posted October 19, 2010 Share Posted October 19, 2010 Using 'Insert into' I am updating my table with new rows which insert at the bottom. However, as soon as I delete a few of the records above the bottom record, the new records I am updating the table with will 'fill these in' and only after that continue at the bottom. Example:My table:ID - Description1 - Some description2 - Some description3 - Some descriptionWhen I delete row 2, and then add the 4th entry to my database (and thereafter the 5th), I will have this:ID - Description1 - Some description4 - Some description3 - Some description5 - Some descriptionBut I want it like this: ID - Description1 - Some description3 - Some description4 - Some description5 - Some descriptionCan anyone help? Thanks in advance.. Link to comment Share on other sites More sharing options...
trevelluk Posted October 19, 2010 Share Posted October 19, 2010 This thread asks the same question, and I've provided an explanation and solution there: http://w3schools.invisionzone.com/index.php?showtopic=33765 Link to comment Share on other sites More sharing options...
MaarX Posted October 20, 2010 Author Share Posted October 20, 2010 This thread asks the same question, and I've provided an explanation and solution there: http://w3schools.invisionzone.com/index.php?showtopic=33765 Thanks, that did it =) Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.