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@...