On Thu, 2008-12-04 at 21:23 +0100, Thomas Steinmaurer wrote:
> > 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/
>
>
>
>
>


[Non-text portions of this message have been removed]