Determining Transaction Success

[Former Member]

I have a method in VB6 and SBO verstion 6.5 that needs to execute after a successful transaction takes place. For example, if a user is entering an AR Invoice, and they have fixed all errors handled by the Application, the AR Invoice is successfully posted to Business One and the process is complete. It is at this point that I need to trigger my method. I've not been able to determine to proper event to capture to do this. What have you guys found to be the best way to accomplish this?

[Former Member · Accepted solution]

Thanks Ibai,

Thats a good way to do it. Is there no way to do it through an add-on distributed to each client app? Just curious.

Also, I am not familiar the "sp_OACreate" and "sp_OAMethod" objects in the T-SQL script. Are these stored procedres, or are they a way in T-SQL to call methods that exist in a registered .dll file?

Thanks very much for the help.

[Former Member · Accepted solution]

Hi,

You could try catching the Create button click, and then get the last added document (there are some trouble with this about 2 users adding at the same time), and do what you need.

I prefer the other option.

Both methods are Transact SQL procedures, which are always avaiable within SQL Server.

Regards,

Ibai Peñ