Finance | Project Operations, Human Resources, ...

Rollback a GP Procedure

(0) Share

Report

Posted on by NCOPP

Good Morning,

I'm asking about the GP procedures with which it is possible to develop wrappers to, for example, combine customers. My question is whether it is possible to control transaction handling of the GP procedure via the wrapper? So, if I wanted to test something I could rollback the changes after verifying the logic was working correctly. Thank you.

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

David Musgrave MVP ... 14,137 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

You can trigger before and after a procedure.

You can start a SQL transaction before and ask to commit or rollback afterwards.

It would depend on how the code in the procedure is written, specifically whether it creates a new SQL connection or uses the existing one.

So in theory it is possible, but would need to be tested to see it works.

It would need either Dexterity or GP Power Tools developer tools to achieve it.

Regards

David

Was this reply helpful? Yes No
NCOPP 92 on at

Like (0)

Report
Copy link

Link copied!

Hi David.

Thanks for the response. Actually, I was able to determine that the GP procedure I was wrapping did in fact look at @@TRANCOUNT to determine whether it should execute within or create its own transaction.

I thought it was not working because I forgot that there are fixed length char fields in GP. As a result when I tested the rollback and expected to see data, I was not seeing it. It is working well.

Thank you!

- Nick

Was this reply helpful? Yes No
David Musgrave MVP ... 14,137 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Awesome. Well done.

Was this reply helpful? Yes No