Subject Re: [IBO] Repost: No current record for fetch operation with join upon SP
Author mmenaz
GREAT!!!!
Now it works as aspected. THANKS A LOT!
As soon as possible, I will try to understand WHY ;)
Maybe SQL is not just drag and drop in a query builder form ;)
Thanks a lot
Marco Menardi
(grazie! ero proprio psicologicamente bloccato e depresso ;)

--- In IBObjects@y..., Lele Gaifax <lele@s...> wrote:
> >>>>> On Thu, 21 Feb 2002 13:32:46 -0000, "mmenaz" <mmenaz@l...> said:
> Hi Marco,
>
> I note that I'm using a different idiom when joining a SP that is
> implicitly linked with the params. In that case, I use
>
> SELECT ...
> FROM table
> JOIN ...
> LEFT JOIN TheSP (table.ID, ...) ON 1=1
>