It will depend slightly on the database. If your database driver back end supports the driver feature LastInsertId, then the easiest way is to call QSqlResult::lastInserId()
You can then do a fetchMore() on the model, and correlate the id to the index... if not, I have done a search for the recently inserted record, get the id, and do the same correlation Scott -----Original Message----- From: interest-bounces+scott=onshorecs....@qt-project.org [mailto:interest-bounces+scott=onshorecs....@qt-project.org] On Behalf Of Knut Krause Sent: Thursday, December 12, 2013 10:16 PM To: interest@qt-project.org Subject: [Interest] How to insert a new record with generated primary key into a QSqlTableModel Hi, I got a DataMapper set up like http://pastebin.com/k9kB1N1a Editing the existing model works really fine but how can I add a new customer? I basically need to insert a new record to the model with an auto generated id (from my DB) and then set the mapper to the correct ModelIndex. How would you do that? regards Knut _______________________________________________ Interest mailing list Interest@qt-project.org http://lists.qt-project.org/mailman/listinfo/interest _______________________________________________ Interest mailing list Interest@qt-project.org http://lists.qt-project.org/mailman/listinfo/interest
