Top "Qtsql" questions

How do I use alias in where clause?

Possible Duplicate: Referring to a Column Alias in a WHERE Clause SELECT Trade.TradeId, Isnull(Securities.SecurityType,'Other') SecurityType, TableName, …

sql sql-server qtsql

What is the correct way of QSqlDatabase & QSqlQuery?

I got confused with the manual , should i work like this: { QSqlDatabase db = QSqlDatabase::addDatabase (...); QSqlQuery query (db); query.exec (...); } …

database qt qt4 qtsql

Using SQLite with Qt

I am thinking of using SQLite as a backend DB for a C++ applicatiojn I am writing. I have read …

c++ qt sqlite qtsql

How to make Qt aware of the QMYSQL driver

I'm trying to access a MySql database from a Qt application but I get the following error: QSqlDatabase: QMYSQL driver …

qt qtsql

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

QSqlQuery::exec: database not open

I'm working on qt, my database was rightly connected with qt but suddenly i have the following problem every time …

database qt qtsql

'EOMONTH' is not a recognized built-in function name- SQL Server 2012

I installed the SQL Server 2012- Developer edition. When I apply SELECT @@version, I get: Microsoft SQL Server 2005 - 9.00.5000.00 (Intel …

sql sql-server qtsql

multiple sql statements in QSqlQuery using the sqlite3 driver

I have a file containing several SQL statements that I'd like to use to initialize a new sqlite3 database file. …

qt sqlite qt4 prepared-statement qtsql

Most efficient way to iterate through a QSqlQuery result set?

I'm querying a remote MSSQL Server database using QODBC and I have a result set returned but it appears as …

c++ sql-server qt odbc qtsql

Correctly using QSqlDatabase in multi-threaded programs

Based on the Qt documentation: A connection can only be used from within the thread that created it. Moving connections …

c++ multithreading qt qtsql