jRDC : Insert command and get last id (primary key)

Hello Community !

I am working with B4A, JRDC2 and MS SQL Server.
I am accessing the DB with several devices (so that table insert commands can come from several devices).

I would like to know if there is a reliable way to implement the following:

With the insert command, I want to insert the LAST id (primary key in the table) in a column:
The insert command in the B4J server-config file looks like (e.g.):
INSERT INTO ORDERS (ID_PRODUCT,PRODUCTNAME,ID_PARENT) VALUES (?,?,?)

Now...

jRDC : Insert command and get last id (primary key)

from B4X Community - Android, iOS, desktop, server and IoT programming tools http://ift.tt/2aJgviY
via IFTTT