i add a column to the database that dynamics sl 2011 is using for inventory. getting an error you have made changes to production database.
How do I update dynamics for the changes to the schema
*This post is locked for comments
Hi,
If you don't have avalible user fields or you don't want to use them, one solution is adding a new custom table and do a customization to do the insert, update and read functions, this table is one to one relatioship with the inventory table. If you are interested i can develop this customization with all the fields that you need.
The .EXE's have the database layouts, columns and order of the columns, embedded in them because dynamics is based on a b-trieve application from way back where everything is an in memory cursor, so the databases cannot have any columns added to them at all ever except by Microsoft. each table does have a 'user1', 'user2', etc that you can commandeer, but you cannot alter the database structure at all. You can add tables and then add that table to a form through customization manager but it is a total pain.
Sorry, I do not know exactly how the newer versions of SL (written in VB.NET) connect to SQL but I believe it does not really matter. The DH files that define the table structure define all the fields even if the particular code does not utilize some of those fields. If you look in the DB\DHFiles folder under Dynamics SL you will see the various DH files for each standard SL table. This may help you understand what I have tried to say.
I do not follow your statement that you can recompile the code. Unless you are under contract with Microsoft to develop/maintain Dynamics SL, you will not have access to the code for the standard SL programs. Therefore, you would not have a way to recompile the code that incorporates the table you tried to modify. What you can do, as Mark stated, is create your own table to hold you new data element(s) and use Customization Manager to include that table in a standard SL screen by providing your DH file for your table and linking your table to data elements on the screen. For example, I have done this with some employee information that my clients wanted that are not included in the standard SL employee screen (e.g., emergency contact number, reason for termination, eligible for rehire, etc.).
But as a developer how is the database connected to the application? Is there a ADO / entity or some other type of access? Does the application use all the columns even though they are not part of the Dynamic application? I realize that these are a few questions but as a developer i am trying to find how it works. if need be I can recompile the code..
Mark is correct with his responses. I am just adding the reason why this is so because knowing why helps explain what might seem like a restriction.
In order for the SL Customization Manager to work, the code must have an "image" of what the data structure is for each table and, hence, that image is embedded in each program that accesses that table. That "image" is the DH files included in the code when it is compiled. Now, before you think you can just change the DH file to match your table change, the key word phrase here is "when it is compiled" which means a program already has that image as it came from the developer.
No, you can't, for the reason I mentioned. The schema files are embedded in the .exes, and you cannot change them.
The correct approach is to create an "extension" table to hold your custom fields, and use VBA customization manager to reference the new table. The CustomizationMgrReferenceVBA.pdf file in the SL\Applications\User Guides folder provides examples on how to do this.
Yes It did cause problems. That is the question can you update the DB to a new schema?
If you are saying you added a column to a standard SL Inventory table, you just broke the system. Schema changes to standard SL tables cause several issues, as the table schema is embedded in the source code of each .exe file, and cannot be changed.
You need to reverse your action to allow the system to function properly.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (