How do I get the id of the record inserted

Scriptcase 9
#1

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)

#2

Hello.
execute a select stament

select LAST_INSERT_ID()

(this returns the last id generated)

1 Like