Hi,

QT use Unicode. It is possible that that is the problem?

baloo


--- In firebird-support@yahoogroups.com, "baloo_der_baer981"
<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
> >
>