Forums > Connected Business Platform > Framework Releated Questions
Subject: Data Dictionary question and problem
Prev Next
You are not authorized to post a reply.

Author Messages
David FUser is Offline

Posts:12
04/08/2008 10:51 AM  
I created several custom columns in several of the SYSTEM tables. 

I then inspected the database using SSMS and noted that the Create and Update sprocs were modified to include my custom columns in the modified tables.

Question:

If I add custom columns to a table with my plugin and another developer adds custom columns to a table with their plugin and an end client installs both plugins -- does one plugin clobber the other or does the end result include the changes from both plugins?

Problem:

I then chose the option to script the DataDictionary from Visual Studio.  I was never presented an opportunity to select generation of a script to include the create/update sproc changes for my custom columns in system tables.  I was given the opportunity to select these sprocs for custom tables, however.

Is including these changes a 'gotcha' step I have to remember to perform each time I make similar database changes?



David Furber
Pete Ian AUser is Offline

Posts:26
04/22/2008 5:10 PM  
Hi,

Yes, the result include the changes from both plugins. Considering that your custom fields are different. Anyway you have to register your plugin. The data dictionary is for for your customization of your database. Once you register that plugin, its create a database record on the separate table and create a separate entity.

Will on your problem about script datadictionary. I have to double check on that, coz i try this before and its work. But I have to make it sure. And if its not going to work i will report this to our core team. Its very important, and may be our core team overlook this functionality.

Pete Ian Angcay
Interprise Solution Developer


Tim SUser is Offline

Posts:30
06/13/2008 8:57 AM  

David

When you select the custom fields on the system tables, the sql created uses 2 IS procedures (AddColumn and UpdateColumn from memory) which add the fields to the relevant table and update the Create/Update stored procedures. 

I know this confused me at first, but it does work.

The stored procedures for custom tables are generally created by you so you need to select them as you may have more than 1 IS project slution involved.
Tim Sheppard, Lerryn Data Technology Ltd
You are not authorized to post a reply.
Forums > Connected Business Platform > Framework Releated Questions > Data Dictionary question and problem


ActiveForums 3.7
Privacy Statement  |  Terms Of Use
Interprise Software Systems International Inc.