On 30/12/2003 23:18 henr-and@dsv.su.se wrote:
> > Can you do the insert using a function instead, and return the currval
> > on the underlying sequence?
> >
> > John
> >
>
> I'm not sure what you mean. A stored procedure?
>
> The good thing about getGeneratedKeys() is that you don't have to write
> DB-specific code.
I always thought that auto-generated keys _are_ db specific. Where are
they defined in SQL92/99?
Back to your problem: Does your app have to support different DBMSs or is
it PostgreSQL-only?
--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for the Smaller
Business |
| Computer Consultants |
http://www.thomas-micro-systems-ltd.co.uk |
+------------------------------+---------------------------------------------+