autonumbering with update command
Posted on 2004-09-04
I made an application that uses datasets to edit/insert/delete data from an Access database and then use the update command to update the database. In my database the id field of my table is an autonumbering field. When I add a row to my dataset, fill it, and use the update command to insert it in my database, I need to somehow retrieve the id field value that my database set during the insert command and put it in my dataset. Is that possible?