Subject | Problem with a SQL Statement |
---|---|
Author | lilpetrova |
Post date | 2003-06-12T10:51:01Z |
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?
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?