Subject Re: [firebird-support] Is it possible to have a view with parameters?
Author Michael Ludwig
W O schrieb am 29.03.2011 um 14:29 (-0400):
>
> There is some way for use a view with distinct data?
>
> For example, to use the same view when the birthday's date is
> '01.01.2001' or '29.03.2002'. Of course, birthday's date is a column
> of the table.

Just use a WHERE clause:

SELECT NAME FROM V_PEOPLE WHERE BIRTHDAY = '29.03.2002';
SELECT NAME FROM V_PEOPLE WHERE BIRTHDAY = '01.01.2001';

--
Michael Ludwig