I have a table with auto-increment column ID. After insert I need to get a new inserted ID. I can’t use Select MAX( ID ) as inserts are in multiuser environment. Tried to use a trigger with a procedure
CREATE TRIGGER SYSADM.TRG_INSERT AFTER INSERT ON SYSADM.TEST
(EXECUTE SYSADM.GETNEW_ID( new.TEST.ID ) )
FOR EACH ROW
On Procedure Startup
On Procedure Execute
On Procedure Close
A procedure call from TD returns nothing. What is wrong?
Checked works fine, in my understanding it's the good idea for the new application and tables. My table has a lot records from 2003, it also has a constraints with child tables, so I have a doubt about worth of all these changes from ID to GUIDs.
Who is online
Users browsing this forum: No registered users and 1 guest