Subject | Re: [firebird-support] Is it possible to have a view with parameters? |
---|---|
Author | Tomas Krejzek |
Post date | 2011-03-31T06:56:58Z |
Hi,
create selectable procedure, and You can do all You want.
Tom
Dne 30.3.2011 23:02, Michael Ludwig napsal(a):
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';
>