![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Reported for Version 2.03 » View Incident Report |
![]() |
Reported By: Franco Fustini Reported On: 8/17/2010 For: Version 2.03 Build 20 |
CREATE FUNCTION "TEST_NUM" () RETURNS INTEGER BEGIN DECLARE I INTEGER DEFAULT -1; START TRANSACTION ON TABLES COUNTER; BEGIN EXECUTE IMMEDIATE 'SELECT CNT INTO ? FROM COUNTER;' USING I; SET I = I + 1; EXECUTE IMMEDIATE 'UPDATE COUNTER SET CNT = ?;' USING I; COMMIT; RETURN I; EXCEPTION ROLLBACK; RAISE ERROR CODE 10000 MESSAGE 'ROLLBACK' + #13 + ERRORMSG(); END; END
This web page was last updated on Tuesday, April 23, 2024 at 08:39 AM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |