* Yolanda Phillips (yphillips@dlkconsulting.co.za) wrote:
> I'm wanting to do an insert, then if it was successfull the function should
> return the id. This id is using a sequence.nextval(). How do I return the
> new id?
After the insert statement, run a new statement:
SELECT curval('sequencename')
This statement will return the id.
Hope this helps,
Anders
--
Anders Hermansen
YoYo Mobile as