How to insert row to SQLite database?

Hi,

I am using SQLite database with QSqlTableModel and QDataWidgetMapper.

I want to insert a new row and save to the database file "database.db"

I have tried "insertRecord" and "insertRows" but I could not save the inserted row to the "database.db" file.

Any clue?

Thanks,
Mohammad

UP
How to insert row to SQLite database?

Using QT or SQLite3 client?

Mecland

I would expect,

Code:

---

QSqlTableModel *model = ...
QSqlRecord record = model->record(); // get your template record from model
record.setValue(...);
model->insertRecord(-1, record); // append record at end
model->submitAll(); // depends on edit behaviour

---

This is untested code ;-)

Thank you I will try it.
I am using Qt

Hi jryanne,

I tried your code but it does not do anything? Any clue?

Thank you,
Mohammad

Hi;
try [WIKI]http://doc.trolltech.com/4.3/demos-sqlbrowser.html[/WIKI].