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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by cmcgarel

  1. cmcgarel

    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...
  2. cmcgarel

    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.
  3. cmcgarel

    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...

Part and Inventory Search

Back
Top