Subject | Re: [firebird-support] Is it possible to have a view with parameters? |
---|---|
Author | Helen Borrie |
Post date | 2011-03-31T00:01:11Z |
At 12:28 PM 31/03/2011, you wrote:
./hb
>There are thousand of birthdays, I can use a SELECT, of course, but it willDid you know that ALL retrievals from a Firebird database are SELECTs? This isn't Paradox, you know! Even if you use a TTable in Delphi, underneath it is doing a SELECT * FROM some table, view or SP. But you should throw away TTable - it was designed for use with Paradox.
>be better having a VIEW.
>Or I can have a Stored Procedure with input parameters, that's my option.That's *another* option. But a view would be more efficient than a selectable SP for this case for several reasons, including that the underlying indexes, if useful, are available.
./hb