How to insert row to SQLite database?

[MIH1406]

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

[MIH1406]

UP
How to insert row to SQLite database?

[mecland]

Using QT or SQLite3 client?

Mecland

[jryannel]

I would expect,

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

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

To copy to clipboard, switch view to plain text mode 

This is untested code ;-)

[MIH1406]

Thank you I will try it.
I am using Qt

[MIH1406]

Hi jryanne,

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

Thank you,
Mohammad

[Naami]

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