Subject | Re: [firebird-support] Re: Sorting and filtering by UDF result |
---|---|
Author | Dany M |
Post date | 2006-03-10T20:16:07Z |
Matt Bucknall wrote:
you could register a view in the repository (assuming there is one) that
is used as the information base for the "engine". My point - the server
does not giva a * if your quieries refer to tables, vies or procedures
(I reserve myselfe for some syntax differences here, imporved in FB 1.5
and even more in 2.0).
Put another way, you could probably "fool" the query generator into
thinking the (persistent, once created) view is a table. The server
would probably not mind.
HTH
/Dany
> Thanks for the suggestion. I considered that approach, but the problemWhat is the source information of the "query generating engine"? Perhaps
> is that the queries are generated dynamically, so I would have to
> create a view dynamically, perform the query, and then destroy the
> view, which is not really practical.
>
you could register a view in the repository (assuming there is one) that
is used as the information base for the "engine". My point - the server
does not giva a * if your quieries refer to tables, vies or procedures
(I reserve myselfe for some syntax differences here, imporved in FB 1.5
and even more in 2.0).
Put another way, you could probably "fool" the query generator into
thinking the (persistent, once created) view is a table. The server
would probably not mind.
HTH
/Dany