you need to "clean up" the system table SQLDictionary to avoid loosing data when moving objects to a lower ID.
You need to create a class that scan the data dictionary in Axapta and match that to the SQLDictionary on name not on id as the standard.
You can browse the SQLdictionary using the enterprise manager.
A table s identified by the table id and field id = zero.
A normal field is identified by the table id and field id, should you have an array (dimensions) you need the array as well to identify the field.
You might find the SQLScan classes useful to se how Microsoft maintains the dictionary.
You might of course export the data and import them into the new system. Be sure to test it before you start this. If your Recid is not unique in the company you will not be able to re-import the company.
/Jesper
-------- Original Message --------
Subject: RE: [development-axapta] Moving code between layers (14-Jun-2004 6:50)
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
> Hi
>
>
>
> 'in the database. I would like to avoid exporting and
> importing with IDs.'
>
>
>
> I guess then you will have export and import data along with the code.
>
>
>
> Regards
>
>
>
> Harry
>
>
>
>
>
> _____
>
> From: Stefan Osterburg [mailto:[EMAIL PROTECTED]
> Sent: Saturday, 12 June 2004 1:01 a.m.
> To: [EMAIL PROTECTED]
> Subject: [development-axapta] Moving code between layers
>
>
>
> Hi,
>
> I am attempting to move my code from the var to the bus
> layer. While this is no problem with an empty database
> I have not been able to do this keeping the data
> in the database. I would like to avoid exporting and
> importing with IDs.
>
> Stefan
>
>
>
>
> Yahoo! Groups Sponsor
>
> ADVERTISEMENT
> click here
> <http://rd.yahoo.com/SIG=129qtu2i4/M=298184.5022502.6152625.3001176/D=gr
> oups/S=1705006764:HM/EXP=1087045464/A=2164339/R=0/SIG=11e2d64in/*http:/w
> ww.netflix.com/Default?mqso=60183348>
>
>
> <http://us.adserver.yahoo.com/l?M=298184.5022502.6152625.3001176/D=group
> s/S=:HM/A=2164339/rand=190594746>
>
>
>
> _____
>
> Yahoo! Groups Links
>
> * To visit your group on the web, go to:
> http://groups.yahoo.com/group/development-axapta/
>
> * To unsubscribe from this group, send an email to:
> [EMAIL PROTECTED]
> <mailto:[EMAIL PROTECTED]
> be>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service <http://docs.yahoo.com/info/terms/> .
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
> To: [EMAIL PROTECTED]
Yahoo! Groups Sponsor | |
|
|
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.