Adam-

Yep, the select works fine, so it must be a feature that hasn't been
implemented yet for views. I'll have to put the coordinate system logic
in the app, as a query that uses the SP.

As it turns out, any server-side processing that I intend to do will only
use rectangular x,y,z coords (to compute transformation matrices), so this
view I wanted was only to make coding the interface a bit simpler :). As
usual, nothing's ever easy...

Thanks,

Elias Sabbagh
Victor Technologies, LLC

On Fri, 8 Jun 2007, Adam wrote:

> --- In firebird-support@yahoogroups.com, Elias Sabbagh <ehs@...> wrote:
> >
> > Adam-
> >
> > I think we're on the right track with the view definition, and
> thanks. I
> > understand why we have to use a left join -- because the table on
> the left
> > is the only true table, and the server has to loop through it first,
> > calling the SP for each record... I've gone ahead and used your SQL to
> > define the view.
> >
> > Unfortunately, now I'm getting a "Dynamic SQL Error: feature is not
> > supported" message! I think that I'm going to have to try a different
> > tack. Perhaps pure stored-procedures instead of views.
> >
>
> I have never tried doing that inside a view (I have joined to a stored
> procedure from in a similar way via a standard query from our app).
> You could certainly do it with a stored procedure (you wouldn't even
> need to do the join in the query, that could be inside the for select
> block.)
>
> Does the select work in its own right? If so it may be a limitation of
> views.
>
> Adam
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>