lcSQL=[CREATE PROCEDURE sp_ww_NewID ]+; [@cName char(30),]+; [@nRetval int OUTPUT ]+; [AS ]+; [UPDATE mytableids ]+; [SET id = id + 1,]+; [@nRetval = id + 1 ]+; [WHERE TableName = @cName ]which is called via SPT with
PRIVATE pnID pnID = 0 lcSQL="Execute sp_ww_NewId '" + lcTableName + "',?@pnID"So my adaption to MySQL is:
lcSQL=[CREATE PROCEDURE sp_ww_NewID (cName char(30), out nRetval integer) ]+; [UPDATE mytableids SET id = id + 1,]+; [nRetval = id + 1 ]+; [WHERE TableName = cName ]and then calling it via SPT with:
PRIVATE pnID pnID = 0 lcSQL="call sp_ww_NewId('" + lcTableName + "', @pnID)"But attempting to call the stored procedure gives the error message: