I am sure I read it anywhere but cannot find it any more: How can I
return an auto-generated identity value after inserting a record from a
stored procedure?

I remember there is something different from (select max...)

Thanks. Uli

Uli,

<< I am sure I read it anywhere but cannot find it any more: How can I
return an auto-generated identity value after inserting a record from a
stored procedure? >>

To retrieve the new identity column value in the procedure, use something
like this:

PROCEDURE "ReturnIdentity" (OUT "ResultIdentity" INTEGER)
BEGIN
  DECLARE InsertStmt STATEMENT;

  PREPARE InsertStmt FROM 'INSERT INTO Customer (CustNo) VALUES (?)';
  EXECUTE InsertStmt USING ResultIdentity;
END

One note - the EDB Manager currently isn't executing "output-param-only"
procedures due to a bug, but they will work fine in your application.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim
> To retrieve the new identity column value in the procedure, use something
> like this:
>
> PROCEDURE "ReturnIdentity" (OUT "ResultIdentity" INTEGER)
> BEGIN
>    DECLARE InsertStmt STATEMENT;
>
>    PREPARE InsertStmt FROM 'INSERT INTO Customer (CustNo) VALUES (?)';
>    EXECUTE InsertStmt USING ResultIdentity;
> END

Thank you!

Regards Uli