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