baloo_der_baer981 wrote:

> 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
>

What's the result if you try this query from Firebirds isql?

Uwe