On Tue, Nov 14, 2006 at 03:54:42PM -0600, John McCawley wrote: > I am once again dealing with that age old problem of retrieving the > value of your inserted serial field in VB. I am fully aware that I can > manually pull the currval or nextval from my sequence, but I consider > having to manually deal with an auto-generated database object an > *extremely* inelegant solution.
Maybe you're looking for lastval()? http://www.postgresql.org/docs/8.1/interactive/functions-sequence.html Have a nice day, -- Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to > litigate.
signature.asc
Description: Digital signature
