Subject Re: [firebird-support] DBKEY or cursor in PSQL
Author Thomas Steinmaurer
> 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?

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