How do you get the primary key ID of each record after a successful save on an in-list edit

[lgrupido]

I am doing an in list edit where I am entering several new records at once.

I want to run some xbasic for each individual record both before and after they are actually inserted into the sql table. (ie: during a detail view list sync)

In a grid the events would be caninsertrecord and afterinsertrecord

The before event will look up some information to insert with the record, the after event will be to add records in other tables once the record is inserted.

Of course, I also need to be able to grab the primary key of the record just inserted.

In the server side event of the detail view there is an after synchronize record event which looks promising, but I don't see how to get the key value of the synched record from in there.

Normally, I would handle most of this with a sql trigger, but I can't do that in this case to stay compatible with the rest of the system.

[cptutrecht]

Currently working on something that might point you in a way to do this(?):

step 1. use {dialog.object}.getListData(UXListName); to give the listdata by function xb callback to serverside (see documentation)
step 2. put it in a pointer and do serverside what you need
step 3. don't store the result of step 2 using xbasic, but give the result back to clientside directly in the list and let the list store the data. see javascript method addTableRowsBulk().

For example (step 3):

dim jsReturn as C
jsReturn = "var listObj = {dialog.object}.getControl('Docusign');listObj.addTableRowsBulk(" + pSignJson + ");{dialog.object}.saveListEdits('DOCUSIGN',{rows: 'allRows'});"
xb = jsReturn

[lgrupido]

I am initially putting the information in there with addtablerowsbulk. What you are suggesting is that I then edit the data all I want, pull it all back out modify it some more, then put it all back and synchronize?

Though, if I'm going to do all that, I may as well save the data serverside and be done with it. That will also fix my other issue of not being able to get the key value. From server side, as I save each record I can get the key.

I will give that a try later today and report back.

[lgrupido]

I tried what you suggested. The getlistdata function is returning the same wrong information. It only sees what was initially put into the list, it doesn't see the manual changes. I think there is some kind of a disconnect between the virtual fields in the inline edit and the fields in the detail view.

full disclosure: I am using the Dec 6 version of Alpha. Will install the latest version to see if that makes a difference.

[cptutrecht]

Yes that works (i expected to ), just understood that you wanted for some reason the data back clientside before storing it to the database. If that is not necessary of course storing directly is what I would to also. And if you wish limit the return to a refresh of the list...

[lgrupido]

I have updated to the latest version of Alpha and it is still not working. Going to send it to Alpha to see if they can help.

[lgrupido]

Ok, I figured out what I was doing wrong. First of all, I was not saving the individual rows after editing them. Synching only commits what was saved for each row. Also, in the after synch record event of the detail view you CAN see the primary key. I just wasn't looking hard enough at the e.data values.