Table's Definition alteration in Dexterity

(0) Share

Report

Posted on by Ehtasham Rahman

670

Hi All!

I am new here in Dexterity. I want to give my customization to my client. In Customization, I have to add the two new fields in a table. What script do I need to write? And where would I write this?

Any help will be highly appreciated. Thanks in advance.

Ehtasham Ur Rahman

*This post is locked for comments

All responses (2)

Answers (0)

Ehtasham Rahman 670 on at

Like (0)

Report

Re: Re: Table's Definition alteration in Dexterity

Thanks Steve Kubis!
Steve Kubis on at

Like (0)

Report

Re: Table's Definition alteration in Dexterity

First, you shouldn't modify table definitions for any existing Microsoft Dynamics GP tables. This includes adding, removing, or changing any fields. Instead, you should create a shadow table that contains the key values and additional data that you want to store with each record.

Look at the "Tables" chapter in the Dynamics GP Integration Guide (included with Dexterity) to learn about how you should design your tables for integrations.

Dexterity supports all of the table types you listed. In earlier releases (4, 5, 6, etc) Dynamics GP supported those other database types. If you choose "Default" as the table type, the runtime will use whatever database provide was chosen for the installation. Today, SQL Server is the only choice, so your table would be SQL. The C-tree type is also still supported. Sometimes it's helpful to store data locally in a c-tree table, such as when processing data in a temporary table. In the vast majority of cases, you'll choose Default or SQL.

Check the Dexterity help file (Dex.chm) included with Dexterity to learn more about the table options.