Subject Re: [ib-support] Views in Firebird
Author Ivan Prenosil
> CREATE VIEW USERS (USER_NAME) AS
> SELECT *
.....
> Interbase accepted it, but Firebird complained about number of columns
> not matching.

Sory, it is just copy-paste error in two of my scripts
(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