--- In firebird-support@yahoogroups.com, Svein Erling Tysvaer
<svein.erling.tysvaer@...> wrote:
The result is the same error. :(

baloo

>
> Try
>
> CREATE TABLE Test(id integer)
>
> (i.e. without the double quotes), then insert your data and try the
> select again.
>
> HTH,
> Set
>
> baloo_der_baer981 wrote:
> > --- In firebird-support@yahoogroups.com, Svein Erling Tysvaer
> > <svein.erling.tysvaer@> wrote:
> > Hi,
> >
> > I use the demo DB from AvERP (you can download it from
> > http://www.synerpy.de/?seite=download&nav=download).
> >
> > I have created the table with:
> >
> > CREATE TABLE "test"("id" integer)
> >
> > But I get the same error if I use the following select statement:
> >
> > SELECT "id" FROM "test"
> >
> > The table creation I had commited.
> >
> > Andre
> >
> >
> >> Hi Baloo!
> >>
> >> How was the database created? I know nothing about QT (not even

if it

> >> works with Firebird), but if a table or field is defined with double
> >> quotes (e.g. CREATE TABLE "test"("id" integer)), then it becomes

case

> >> sensitive. Your select will be converted to all uppercase, i.e.

SELECT

> >> ID FROM TEST unless you double quote the field and table name
> > separately
> >> (SELECT "id" FROM "test"). Though I would rather recommend

creating the

> >> table/field without double quotes to avoid case sensitivity.
> >>
> >> Your query seems OK, but the error indicates that it is not, and
> > that is
> >> why I guess it has something to do with the table or field name.
> >>
> >> Oh, one more thing. You do not mention transactions. Creating a
> > table is
> >> DDL, and that transaction has to be committed before you do your DML
> >> (select, insert etc.). Just thought I should mention this in case

your

> >> are doing the select just after you created your table.
> >>
> >> HTH,
> >> Set
> >>
> >> 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
>