Subject Re: [firebird-support] Is it possible to have a view with parameters?
Author Tomas Krejzek
Hi,

create selectable procedure, and You can do all You want.

Tom

Dne 30.3.2011 23:02, Michael Ludwig napsal(a):
> 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';
>