|Subject||Re: [firebird-support] DBKEY or cursor in PSQL|
> This is probably a newbie question but I have never before tried thisPerhaps this one helps?
> 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 some work>
> update YAK set Foo=:var_work where RDB$DB_KEY=:var_yak;
> I need to know what type of variable :var_yak needs to be defined as.
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and