Top "Qsqlquery" questions

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

How to get numbers of rows and columns using QtSql?

I have read the Qt documentation and can't find a direct way from the language itself to get numbers of …

c++ mysql qt qtsql qsqlquery