QSqlTableModel programmatic changes

[JD2000]

try putting

timestamp DATE DEFAULT (datetime('now','localtime')),

timestamp DATE DEFAULT (datetime('now','localtime')),

To copy to clipboard, switch view to plain text mode 

in your sqlite schema

[jtdavidson]

Thanks. In the end I wrote a trigger into the schema that operated as soon as a line was added.
But still I wonder why my first approach didn't work. You can't change a value in a table model before you submit it? Or am I just going about it the wrong way? Do I have to abstract a record model first, or something, rather than accessing tablemodel.record().setvalue ?

John