--- In firebird-support@yahoogroups.com, Uwe Grauer <mailinglists@...>
wrote:


With ISQl works all fine - no problems correct result.

baloo

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