Subject | Re: [firebird-support] Is it possible to have a view with parameters? |
---|---|
Author | Michael Ludwig |
Post date | 2011-03-30T21:02:38Z |
W O schrieb am 29.03.2011 um 14:29 (-0400):
SELECT NAME FROM V_PEOPLE WHERE BIRTHDAY = '29.03.2002';
SELECT NAME FROM V_PEOPLE WHERE BIRTHDAY = '01.01.2001';
--
Michael Ludwig
>Just use a WHERE clause:
> 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.
SELECT NAME FROM V_PEOPLE WHERE BIRTHDAY = '29.03.2002';
SELECT NAME FROM V_PEOPLE WHERE BIRTHDAY = '01.01.2001';
--
Michael Ludwig