resetting id while deleting records in runtime
-
after i had delete the records by the following line: objConnection.execute "DELETE * FROM tea_session_list" what should i add to the statement to have the autonumber id also being resetted to be start at 1. i dun wan to do it by compacting database...can i do it in a new script with the delete statement....what should i add to my above statement???
-
after i had delete the records by the following line: objConnection.execute "DELETE * FROM tea_session_list" what should i add to the statement to have the autonumber id also being resetted to be start at 1. i dun wan to do it by compacting database...can i do it in a new script with the delete statement....what should i add to my above statement???
The only resonable solution to this I see is if you control the ID yourself. Either use a MAX value or a second table that stores the next ID value.