Subject Re: CURSOR or WHERE CURRENT OF in a stored procedure
Author Alexander V.Nevsky
--- In ib-support@yahoogroups.com, "Martijn Tonies" <m.tonies@u...>
wrote:
> Hi,
>
> 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?

Use the source, Martijn :) You know, there are some interactive
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.