> This is probably a newbie question but I have never before tried this
> particular trick. (I always use surrogate keys, go figure)
>
> I have a table where I want to update a specific row returned from a
> query, but, the only guaranteed unique identifier happens to the dbkey.
> This is for a one-time process that I wish to perform in PSQL.
>
> for example
>
> for select FOO, RDB$DB_KEY from YAK into :var_foo, :var_yak
> do
> begin
> <do some work>
> update YAK set Foo=:var_work where RDB$DB_KEY=:var_yak;
> end
>
> I need to know what type of variable :var_yak needs to be defined as.

Perhaps this one helps?
http://www.cvalde.net/document/practical_use_of_the_rdb.htm


--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com
My blog:
http://blog.upscene.com/thomas/