Re: A way to get autogenerated keys

Salch, Chris ha escrito: > I need a way to find an auto generated key after an insert statement. [snip] > Any suggestions? Why do you need it *after* the insert statement if you can compute one *before*? We have sequences in Informix since 9.40. I'd really want to know why and when to use sequences or dbinfo(). > > (If there is a nice way to get the ibm jdbc driver to return it's keys according to the jdbc standard and not some obfuscated method I would gladly settle for that :) Talking about drivers, a shameless self promotion follows: the Informix driver for Ruby has reached precisely some minutes ago its version 0.4.0. You can get it from Rubyforge. -- Gerardo Santana