Top "Qsqlquery" questions

The QSqlQuery class, part of the Qt framework, provides a means of executing and manipulating SQL statements.

Sql query to create a calculated field

I have a database table like this: I hope I can explain this well, so you can understand. I want …

sql database ms-access qsqlquery
Qt QSqlQuery bindValue works with ? but not with :placeholders

I'm working with SQLite, doing insert into table. Folowwing QSqlQuery testQuery(QString("INSERT INTO test(testcol) VALUES(?)")); testQuery.bindValue(0, someQStringObg); …

c++ database qt sqlite qsqlquery
Qt 5 with SQLite: bindValue() results in "Parameter count mismatch" error

I'm doing a simple parameterized query with Qt 5.3.1 (64-bit) on Windows 7 using the SQLite driver. When I use bindValue() to …

qt sqlite qt5 qtsql qsqlquery
Query Azure SQL Database using Rest-API

I have a SQL database server in Microsoft Azure. I want to use Azure Rest-API to select some records from …

sql-server api azure restful-url qsqlquery
QSqlQuery with prepare and bindValue for column name Sqlite

void updateDB(const int id, const QString& column, const QVariant& value) const //***** //all stuff on open DB etc. …

c++ sqlite qt qsqlquery
How do I select from a specific number of rows?

In a SQL query, how do I select a specific number of rows from row number 10 to 50, for example. SELECT …

mysql sql sql-server qsqlquery