[Qt-interest] Database abstraction with QSqlQueryModel

[Neville Dastur]

On 25/08/10 01:20, Tony Rietwyk wrote:
> Hi Neville,
>
> Have you tried setting your own query, then using
> QSqlQueryModel.setQuery(const QSqlQuery&query)?
>
> What problems did you encounter?
>    
Firstly, completely missed that in the docs. So thank you for pointing 
it out.

Secondly, for anyone else that uses it. You must do an exec() on the 
query before setting the query in query model.

i.e.

QString sql("SELECT name FROM myTable WHERE id = :id");
QSqlQuery query;
query.prepare(sql);
query.bindValue(":id", national_id);
query.exec(); // <<< This step is essential and must not result in a 
forward only result set

QSqlQueryModel::setQuery( query );