Helpful Information
 
 
Category: Firebird SQL Development
return new identity from stored procedure

hi...
i need to retrive new identity value after an insert command.
i think that a stored procedure is the answer, but i don't know how i can use it for my goal...
(example:
INSERT INTO users(name) VALUES('john');
i need know the jhon's user_id - the primary key)
tnx










privacy (GDPR)