Dear Jesper,
I am running axapta 3.0 sp3. To simulate the situation I did some testing in a test-environment and in a development-environment. I created a new field for the table VendTable in both environments. In my test-environment I did it in the usr layer. In my development environment I did it in the var layer. Same name for the field. I entered data in the field for the records in my test-environment. I logged out of both environments. I removed the axusr.aod and related files from the test-environment application directory. I copied the axvar.aod and related files from the development-environment to the test-environment application directory. I started the axapta test-environment. Axapta then starts building the axapd.aoi, axapden-us.khi and axapden-us.ahi files. After that I logged in and checked whether the data entered previously was still there. I checked the field id, which was changed from 500001 into 300001. The data was still in the fields. regards, Danny --- In Axapta-Knowledge-Village@yahoogroups.com, "Jesper Kehlet" <[EMAIL PROTECTED]> wrote: > Your explanation is a little confusing: Did you do a synchronize in > your own environment? What version of Axapta are you using? > > ________________________________ > > From: Danny Gaethofs [mailto:[EMAIL PROTECTED] > Sent: Monday, January 10, 2005 9:57 AM > To: Axapta-Knowledge-Village@yahoogroups.com > Subject: [Axapta-Knowledge-Village] Re: VAR/USR Layer changes and data > > > > Dear all, > > The reason for my question was that my customer made noticed after > they installed the var layer that the field values were deleted. > > I did some testing in my own environment. I removed the USR layer > file axusr.aod and related files and replaced them by axvar.aod. > After logging back into axapta I saw the id's of the fields were > changed from 500001 to 300001. > > The data in the fields was not deleted. > > I conclude that using this approach replacing axusr.aod with > axvar.aod will not change the content of the fields in the table > being modified. Only thing that is changed are the id's. > > regards, > Danny > > --- In Axapta-Knowledge-Village@yahoogroups.com, "Jesper Kehlet" > <[EMAIL PROTECTED]> wrote: > > Use the SQL Administration/Tables/Synchronize -- it works just > fine, at > > least in 3.0. > > > > Another way to go about this, and if it's only a few fields > (Caution: > > Should be done in 2-tier mode with AOSs shut down, and without > anybody > > else in the system!): > > > > 1. In the SqlDictionary table, find the fields, and change > their > > field ids to the new field ids (5xxxx -> 3xxxx), then log out. > > 2. Put the new VAR/USR layer in there. > > 3. Start Axapta and perform synchronization to create other > new > > fields etc. > > > > Of course, test it in a test environment before you perform > updates in > > live environments -- you may experience some trouble that causes > it to > > go haywire, especially in heavily customized systems. > > > > ________________________________ > > > > From: Danny Gaethofs [mailto:[EMAIL PROTECTED] > > Sent: Monday, January 10, 2005 8:12 AM > > To: Axapta-Knowledge-Village@yahoogroups.com > > Subject: [Axapta-Knowledge-Village] VAR/USR Layer changes and data > > > > > > > > Dear all, > > > > One of my customers has made table changes in the usr layer. They > > added new fields. These fields have been used already in their > > production database and of course values have been entered. > > > > Now I need to transfer these changes to the VAR layer. > > > > I notice when I just export the changes and import them in the var > > layer, nothing happens. Is this correct, I assume it is a way the > > software is trying to keep things consistent. As such it is not > > possible to overwrite changes made in the user layer. > > > > Am I correct that it is not possible to load these changes into > the > > var layer while they are still in the usr layer. Is this behavior > > only valid for tables? > > > > How can I get the changes transferred to the var layer without > > loosing the data already entered. > > > > regards, > > Danny Gaethofs > > > > > > > > > > > > Sharing the knowledge on Axapta. > > > > > > > > ________________________________ > > > > Yahoo! Groups Links > > > > > > * To visit your group on the web, go to: > > http://groups.yahoo.com/group/Axapta-Knowledge-Village/ > > > > * To unsubscribe from this group, send an email to: > > [EMAIL PROTECTED] > > <mailto:[EMAIL PROTECTED] > subject=Uns > > ubscribe> > > > > * Your use of Yahoo! Groups is subject to the Yahoo! Terms of > > Service <http://docs.yahoo.com/info/terms/> . > > > > > > Sharing the knowledge on Axapta. > > > > ________________________________ > > Yahoo! Groups Links > > > * To visit your group on the web, go to: > http://groups.yahoo.com/group/Axapta-Knowledge-Village/ > > * To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED] subject=Uns > ubscribe> > > * Your use of Yahoo! Groups is subject to the Yahoo! Terms of > Service <http://docs.yahoo.com/info/terms/> . ------------------------ Yahoo! Groups Sponsor --------------------~--> In low income neighborhoods, 84% do not own computers. At Network for Good, help bridge the Digital Divide! http://us.click.yahoo.com/EpW3eD/3MnJAA/cosFAA/kGEolB/TM --------------------------------------------------------------------~-> Sharing the knowledge on Axapta. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/