It has been a while since I have done a lot of Dexterity integration work but I need to be able to create new SOP transactions using Dexterity. I know there is eConnect that can be used through VSTools and SQL but am not sure if there is something similar or a way to access the eConnect stored procedures through Dexterity. I have done it in the past by adding records to all of the affected tables but am hoping things have changed and there is a better way to do this as this method does not enforce any built in business logic the way eConnect does.
Can anyone point me to any links for learning how to do this?
Thanks!
*This post is locked for comments
I have the same question (0)You can call eConnect stored procedures from Dexterity via one of two mechanisms:
1. You can create a prototype procedure (sproc) from Dex for the eConnect stored proc. Take a look at my article dynamicsgpblogster.blogspot.com/.../calling-sql-server-stored-procedures.html
2. You can use pass-through SQL from Dex. This old thread shows how to use the SQL_Execute(), microsoft.public.dynamics.gp.developer.narkive.com/.../complex-database-queries-in-dexterity