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
jmcgarvey 8/28/2009 1:37:28 PM

Creating new Tables in Visual Studio for Dynamics GP

hi all,

Firstly it's great to see that there's a forum out there for all us GP devs. Thanks for setting this up.

I've done a lot of dex devs in the last 10 years but this week I decided to take the plunge and start looking at developing for GP using the VST. I've got everything installed and working and following some of the tutorials out there I've created a couple of small add-ins.

I've got a really smally dev project coming up (just a couple of mantenance windows) and I'd like to do this using VS. I cannot however figure out how to define tables, like I would in dex using Visual Studio. So I have a couple of questions that hopefully somebody will be able to help me with.

- Can I define tables in Visual Studio like I could in Dex?
- If not, should I just define them in SQL, and create them at run time from my add in?
- If I do create them through SQL, do I need a Dex row ID?

I understand I could create a new dic in dex with the tables I need and then use them through Visual Studio, I suppose I'd rather not have to. Going back into dex to do this seems to be backwards step.

Thanks in advance.



Version: Unknown or N/A
Section: Visual Studio Tools for Dynamics GP

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