Subject Re: [firebird-support] Is it possible to have a view with parameters?
Author W O
Hello Helen

Thank you very much for your answer.

I am not using Delphi (know it, but I dont use it since several years ago),
my main language is Visual FoxPro and Firebird works excellent with it.

If a view is more efficient than a select then I'll use a view, of course.
Thank you for your advice.


On Wed, Mar 30, 2011 at 8:01 PM, Helen Borrie <helebor@...> wrote:

> At 12:28 PM 31/03/2011, you wrote:
> >There are thousand of birthdays, I can use a SELECT, of course, but it
> will
> >be better having a VIEW.
> Did 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.
> >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

[Non-text portions of this message have been removed]