Subject | Re: CURSOR or WHERE CURRENT OF in a stored procedure |
---|---|
Author | Alexander V.Nevsky |
Post date | 2003-06-05T09:01:58Z |
--- In ib-support@yahoogroups.com, "Martijn Tonies" <m.tonies@u...>
wrote:
tools for FB which can show you compiled BLR of the procedure ;)) In
short - it is based on rdb$db_key. Explicit usage of this is
documented at www.cvalde.com/document/mysteriousDbKey.htm and
www.cvalde.com/document/practical_use_of_the_rdb.htm, implicit (where
current of) saves one more small portion of time not making
positioning before modify.
Best regards, Alexander.
wrote:
> Hi,Use the source, Martijn :) You know, there are some interactive
>
> Right - I've found the syntax after all ...
>
> > I've been searching high and low, but cannot find it ...
>
> But - how does it work? Do you need to at least
> select the primary key columns in the FOR SELECT
> clause in order to update such a table? Is there a
> usuable example out there?
tools for FB which can show you compiled BLR of the procedure ;)) In
short - it is based on rdb$db_key. Explicit usage of this is
documented at www.cvalde.com/document/mysteriousDbKey.htm and
www.cvalde.com/document/practical_use_of_the_rdb.htm, implicit (where
current of) saves one more small portion of time not making
positioning before modify.
Best regards, Alexander.