DataObjects/core_functions.sql

diff --git a/DataObjects/core_functions.sql b/DataObjects/core_functions.sql
index d1e360f..4f6a5ee 100644 (file)
--- a/DataObjects/core_functions.sql
+++ b/DataObjects/core_functions.sql
@@ -16,14 +16,14 @@ DELIMITER ;
 
 
 
-DROP PROCEDURE IF EXISTS core_enum_seqmax_update;
+DROP FUNCTION IF EXISTS core_enum_seqmax;
 DELIMITER $$
 CREATE PROCEDURE core_enum_seqmax_update( etype varchar(128))
 BEGIN
         DECLARE seqmax INT(11);
         SELECT MAX(seqid) +1 INTO seqmax FROM core_enum WHERE
             etype = etype;
-        UPDATE core_enum SET seqmax = seqmax WHERE etype = etype;
+        RETURN seqmax;
         
     END $$
 DELIMITER ;