More than one user use the same stored procedure at the same time

[Former Member]

Hi all,

I have created a user form. In this form, there are several fields, that are taking its values from the results of a stored procedure, that are stored in a table.

My problem is that if more than one SAP user opens the form at the same time, the stored procedure is triggering for each user. Thus, the table is keeping the results of the latest execution of the sp and that leads to a conflict between the data that are presenting to each user's form.

Any suggestions??

Thank you,

Aris Pantelatos

[Former Member]

Petr,

Thank you for your reply. I thought about that too, but I was hoping that there was something through DI that I could use to achieve my goal. Is there any kind of limitation to set, in order to avoid even the execution of the stored procedure the same time?

Aris

[Former Member]

Hi Edward,

I forgot to say, that the table is a user defined table.

The stored procedure is used, just to return some results in this user defined table and nothing more than that.

Aris

[Former Member]

before calling sp you may define unique identifier and pass it as parameter to stored procedure. The stored procedure will return then only the datas with this identifier...

[Eneveux]

Aris,

Other than the use of the SAP Business One SP_TransactionNotification stored procedure, SAP does not allow for the use of stored procedures to be used when integrating with SAP Business One. This is defined per the SAP Note 89689.

Unless I am misunderstanding you and you are using the SP_TransactionNotification? For more information on the use of this stored procedure see ....

/people/lisa.mulchinock/blog/2009/05/22/the-sptransactionnotification-stored-procedure

Eddy