Hi Alexander,

> > 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

Right - I get this (with a DELETE FROM ... WHERE CURRENT OF):

blr_erase, 0,

Which doesn't give me a clue :)

> 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.

Ok - thanks for that. So it's actually pretty easy :-) :-)


With regards,

Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions
http://www.upscene.com