Subject | Re: [ib-support] Views in Firebird |
---|---|
Author | Ivan Prenosil |
Post date | 2002-05-24T16:42:05Z |
> CREATE VIEW USERS (USER_NAME) AS.....
> SELECT *
> Interbase accepted it, but Firebird complained about number of columnsSory, it is just copy-paste error in two of my scripts
> not matching.
(isc4_log.sql.txt and isc4_time.sql.txt).
It can be easily fixed by changing this row
CREATE VIEW USERS (USER_NAME) AS
to
CREATE VIEW USERS AS
I just tried it with Firebird and it works o.k.
The irony is that it was me who fill the bug report
that lead to fix in FB that such views are refused :-)
Ivan
http://www.volny.cz/iprenosil/interbase