Native Development

[JeffLemon]

I want to get data from my datatbase as a QVariantList using a select query.

So far I have:

QVariantList sqlData;
QSqlQuery sqlQuery(mDb);
sqlQuery.prepare("select * from users");
sqlQuery.exec();
sqlData = sqlQuery.???
return sqlData;

 How can I get all rows from the database? I only seem to find get row not rows.

[simon_hain]

if i don't need the key returned i use:

QVariant result = sqlDataAccess->execute("SELECT * FROM users");
QVariantList list = result.value<QVariantList>();

 (you can get the values of the variants using qDebug())

If i need the key i use:

QSqlQuery sqlQuery(queryString, sqlDataAccess->connection());
sqlQuery.exec();
int key= sqlQuery.lastInsertId().toInt();