How do I get the id of the record inserted

Hello.
How do I get the id of the record inserted with the macro sc_exec_sql?
Example:
$ id = sc_exec_sql (“INSERT INTO …”);
(this returns the sql statement but not the inserted id)

Hello.
execute a select stament

select LAST_INSERT_ID()

(this returns the last id generated)

1 Like

🚀 Scriptcase 9.12 is now available! Check out the new features here 👉🚀 Next Monday (02/24), Scriptcase 9.12 will be released! Check out the new features before anyone else 👉