--- In firebird-support@yahoogroups.com, Svein Erling Tysvaer
<svein.erling.tysvaer@...> wrote:

Hallo,

if I try it with the QT programm i get the same error. But with ISQL
all works fine - no error and the result is in 1.

baloo

> OK, then try these two queries:
>
> SELECT COUNT(*) FROM RDB$RELATIONS
> WHERE RDB$RELATION_NAME = 'TEST'
>
> and
>
> SELECT COUNT(*) FROM RDB$RELATION_FIELDS
> WHERE RDB$FIELD_NAME = 'ID' AND RDB$RELATION_NAME='TEST'
>
> These should both return 1 if you have defined the table correctly.
>
> Set
>
> baloo_der_baer981 wrote:
> > --- 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
>