Sending and Receiving data to/from SQL server
I am developing a custom dialog programming screen in SAP.
The user will enter Sales Order number on the screen and clicks on a button.
The Sales order details should be passed to Microsoft SQL server and saved in a table. An event runs immediately in SQL server to process this data passed from SAP and saves the results in second table in SQL server. Then SAP has to pull the data from this second table in SQL server and display the results on the second screen in the custom screen in SAP.
All of this should happen when the user clicks the button on the first screen of SAP transaction.
How can I send data to SQL server and wait in the same transaction to get back the results from SQL server?
Your thoughts are greatly appreciated.