Dmitry,
What does this give you?
SELECT T.*, PROC.*
FROM TABLE T, PROC(T.ID)

h.


At 04:19 PM 30-10-00 +0300, you wrote:

>Hello, Ivan!
>
>Ivan Prenosil wrote:
> >
> > > >SELECT T.*, SP.*
> > > >FROM TABLE T, PROC(T.ID) SP
>
> > > Interesting problem. Does the error occur before the
> > > first row is returned?
> >
> > Prepare - o.k.
> > Open - o.k.
> > First fetch - booom.
> >
> > (but it perhaps depends on PLAN, so I would expect this error
> > to occur during Open in some cases)
>
>I've tested in IB_WISQL - only prepared this query without execution.
>This query does not return query plan!
>
>And there is no query plan when I add where clause and query does not
>return "no current row" error.
>
>Seems that optimizer is VERY confused :-)
>
>p.s. IB 6.0.0.627 for Windows NT (4.0 SP6a). TCP/IP connection.
>
>--
>Dmitry Kuzmenko, Epsylon Technologies.
>
>To unsubscribe from this group, send an email to:
>IB-Architect-unsubscribe@onelist.com
>

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
___________________________________________________