Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now!Log In
SteveGray 1/3/2013 12:17:31 PM

Integration Manager - sample data access code

This article contains a code sample for doing data access in Integration Manager. The source of the code is the IM script library, but there are bugs in that code and it also does not allow you do select a specific database.

The connection string includes a hard coded sa password, and the sql is 'pass through SQL', both techniques that we don't recommend. They're in this sample because they're the quickest thing to do.

Version: GP 9,GP 10,GP 2010
Section: Integration Manager

Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables