B4J Question jRDC - Returning id from record insert into a table.

[vfafou]

Hello!
I need to get the returning id from record insert into my database, with the use of the jRDC framework!
Does anyone have implemented this functionality?

 

[Alexander Stolte]

Create a Stored Procedure where you make the INSERT and after the INSERT you do a select and get the LAST_INSERT_ID and returns this.

 

[vfafou]

Create a Stored Procedure where you make the INSERT and after the INSERT you do a select and get the LAST_INSERT_ID and returns this.

Hello Alex!
Thank you for your response!
I'm trying to see if the answer of the httpjob returns the response with the returning id from database.
I've just added into my config file of jRDC2 the clause "returning id" at every insert statement and I'll see if it the job returns it.

 

[vfafou]

Create a Stored Procedure where you make the INSERT and after the INSERT you do a select and get the LAST_INSERT_ID and returns this.

Another idea could be to create a stored function in the database, returning the id and get it in the app.

 

[josejad]

Hi

You can see how to get it here

jRDC2 Add MySql Master / Detail

Hi: Searching several threads in the forum, I've used this code to add a row in a "master" table, and then the "children rows" in a "detail" table. May be useful to someone. Improvements are welcome. Table Master: id (primary, autoincrement), field 1, field 2... Table Detail: id, master_id...

www.b4x.com

 

[OliverA]

Another possible solution (requires modification to servers side jRDC2 and client side DBRequestManager).

Thread 'Alpha/Beta testing if jRDC2 with returning auto-generated key values after INSERT' https://www.b4x.com/android/forum/t...uto-generated-key-values-after-insert.126407/

 

[vfafou]

Hello! Thank you all for your responses!
I finally did it without any change!
I just do the insert with ExecuteQuery.
I have written my insert as:

INSERT INTO table (f1,f2,f3,...)
VALUES (v1,v2,v3,...)
RETURNING id

so the DBResult is one row containing the id returned from the insert.