Subject | Queryerror by Firebird - QT Connection |
---|---|
Author | baloo_der_baer981 |
Post date | 2006-08-25T07:23:30Z |
i my problem:
I build a db connection to an 1.5 Firebird db server whit QT - no
problems. I open the connection - no problem. But if I execute a
QSqlQuery I get the following error from query.lastError().text() and
query.lastError().databaseText():
Unsuccessful execution caused by system error that does
not preclude successful execution of subsequent statements
Could not prepare statement
code:
QSqlDatabase db = QSqlDatabase::addDatabase("QIBASE");
db.setHostName("127.0.0.1");
db.setDatabaseName("xxx");
db.setUserName("SYSDBA");
db.setPassword("masterkey");
if(db.open())
{
QSqlQuery query;
query.exec("SELECT id FROM test");
}
I have checked the following things:
1. the table exist
2. the colum exist
3. db.lastError().driverText() return no error
4. db.lastError().databaseText() return no error
I hope you can help me. Thanks.
baloo
I build a db connection to an 1.5 Firebird db server whit QT - no
problems. I open the connection - no problem. But if I execute a
QSqlQuery I get the following error from query.lastError().text() and
query.lastError().databaseText():
Unsuccessful execution caused by system error that does
not preclude successful execution of subsequent statements
Could not prepare statement
code:
QSqlDatabase db = QSqlDatabase::addDatabase("QIBASE");
db.setHostName("127.0.0.1");
db.setDatabaseName("xxx");
db.setUserName("SYSDBA");
db.setPassword("masterkey");
if(db.open())
{
QSqlQuery query;
query.exec("SELECT id FROM test");
}
I have checked the following things:
1. the table exist
2. the colum exist
3. db.lastError().driverText() return no error
4. db.lastError().databaseText() return no error
I hope you can help me. Thanks.
baloo