Hi - First, I'm helping develop a web-based application using PowerBuilder, the EAF, and JSP.
I'm performing an INSERT, but directly afterwards need to grap the new PK and send it to a JSP page. The insert is instigated by a buttonPress on the webpage. The function controlling that button calls 'dataset'.buttonPress('Update', 0, 'b_update'). I'm doing the insertrow(0) in retrieveStart, and this works like a charm. The problem is that there is another table who's data is dependent on this newly inserted data (the PK of the insert is an FK of the second table). I need to grab that new PK, real-time, and send it to a JSP page.
Does anyone have any suggestions?
I'm performing an INSERT, but directly afterwards need to grap the new PK and send it to a JSP page. The insert is instigated by a buttonPress on the webpage. The function controlling that button calls 'dataset'.buttonPress('Update', 0, 'b_update'). I'm doing the insertrow(0) in retrieveStart, and this works like a charm. The problem is that there is another table who's data is dependent on this newly inserted data (the PK of the insert is an FK of the second table). I need to grab that new PK, real-time, and send it to a JSP page.
Does anyone have any suggestions?