Subject Re: [firebird-support] Re: Sorting and filtering by UDF result
Author Dany M
Matt Bucknall wrote:
> Thanks for the suggestion. I considered that approach, but the problem
> 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.
>

What is the source information of the "query generating engine"? Perhaps
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