Subject Re: [ib-support] Views with parameters
Author Helen Borrie
At 07:27 AM 6/06/2003 +0000, you wrote:
>hello.
>
>
>I read the documentation but I can't confirm if I can do or not views
>(stored procedures not) with input parameters in firebird's data
>bases.
>
>
>If I can do this, someone can put a small code example for the CREATE
>VIEW command?

You don't create a view with parameters. You create a view (see the
Language Reference for syntax) and then you can operate on the view just as
if it were a table - including passing parameters in the where clauses of
your SELECT and DML statements.

You can include a WHERE clause in your view specification.

heLen