Hi,

Yes, you are right but actually this statement is generated from
Oracle BC4J and as it is raising an error I am trying to find some
documentation saying that such queries (subselects, unnamed views,
etc.) are not working on Firebird database.

Could you help me with some documentation about special features on
Firebird?





--- In Firebird-Java@yahoogroups.com, Stefan Mühlemann <smue@o...>
wrote:

> Hello,
>
> shouldn't the statement be:
>
> SELECT COUNT(ID) ESTCOUNT
> FROM BUSINESS_TYPES;
>
> ???
>
> Stefan
>
> lilpetrova schrieb:
> > Hi,
> >
> > I am trying to execute this statement on Firebird:
> >
> > SELECT count(1)
> > FROM
> > (SELECT ID, CLIENT_TYPE, SERIAL_NO, ENABLED
> > FROM BUSINESS_TYPES)
> > ESTCOUNT
> >
> > It gives me the following error:
> > Dynamic SQL Error
> > SQL error code = -104
> > Token unknown - line 3, char 2
> >
> > There is no information that such query will not work on FireBird
> > database.
> >
> > Could you help me with some information on that issue?
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > To unsubscribe from this group, send an email to:
> > Firebird-Java-unsubscribe@yahoogroups.com
> >
> >
> >
> > Your use of Yahoo! Groups is subject to

http://docs.yahoo.com/info/terms/

> >
> >
>
> --
> Stefan Mühlemann
>
> odin5 GmbH
> Mühleweg 21b
> CH - 4900 Langenthal
>
> Fon ++41 (0)62 923 06 65
> Fax ++41 (0)62 923 06 66
> Mobile ++41 (0)79 403 99 67
> Mail smue@o...