Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Adding custom trigger to GP DB
To answer my own question, I was executing a method in an ActiveX dll using OLE Automation with the SQL Server sp_OAMethod procedure. The dll was executing in-process and interfering with SQL Server's memory space. I altered my dll to an ActiveX exe and invoked it out-of-process and the error...- cmcgarel
- Post #2
- Forum: Microsoft: Dynamics GP (Great Plains)
-
Documentation on what is in the tables
I second this post. Where is the technical documentation for Great Plains? My integration project has been very painful to plug-in to GP and full of trial and error and inferrence. Some human-readable descriptions of each table and field in a PDF would make all the difference.- cmcgarel
- Post #2
- Forum: Microsoft: Dynamics GP (Great Plains)
-
Adding custom trigger to GP DB
Hi, I am trying to add a custom trigger which will be fired when a n invoice is posted. I have created it on the SOP30200 table (in SQL Server). The trigger fires fine when I hard-code an INSERT using SQL Query Analyser. However when I post an invoice from GP the trigger seems to interfere with...- cmcgarel
- Thread
- Replies: 1
- Forum: Microsoft: Dynamics GP (Great Plains)
