Dear All,
Please tell me how can i refresh the Database from Code Unit.
My requirement is, I did some midifications in the Code Unit and i want to update the same on all client system at the same time when i save the modified code unit.Because multiple users are working in the same database.Is there any facility to update the database with recent code .(something like Refresh....etc)..Please Explain
Thanks & Regards
Rose :roll:
0
Comments
Development Database -> Testdatabase (if ok) -> Livesystem at Night or in the morning when nobody is logged on.
To change the Object Cache is not e good tip because the system reads ever the object table so, for example it loads ever the posting codeunits .....
If you are under 5.01 you can create your own "Auto" Update process.
viewtopic.php?f=5&t=27874
[-X [-X [-X [-X [-X [-X
Why would you do this? Sure its great to answer a persons question, but how does this help them. The OP will probably just read the first sentence and say "Ah problem solved, I will just set the cache and its fixed". People after quick fixes don't look at the implications, and don't care about the "I don't recommend" they just care about the solution.
The ONLY solution is to work in a controlled environment and have the users log out. Sure that might change in the future with the new import object features in 2009, but not now.
In any case setting cache to zero is EXTREMELY dangerous. Since you haven't got a clue what was changed. So there could be a sequence of code, say you open a form, that form sets some values in a table, a new form is launched from a button, there some code checks the status of those fields and runs some code. YES the objects may be refreshed, BUT only the new ones you read. So earlier down the track the status is still set with the old code. Now if you are lucky you will get an error message causing the user to quit and start again, but its also likely that you will have already run part of the old code and now part of the new code. This could be (for example) disastrous in the planning engine where there are many pieces of code called in sequence. Also many code changes require update routines. Which may or may not have run, or worse may have only partially run.
SETTING THE CACHE TO ZERO IS NOT AN OPTION.
...SO at present ,the only solution for this is Log Out..Isn't it??
Thanks
Rose
\:D/ YES!
You can also restart the server :twisted: that would force then to log back in
http://www.BiloBeauty.com
http://www.autismspeaks.org
Why so hard, i would kill all session ;-) instead of rebooting the servermachine :-) Its faster :-D
No, redrose, use the way that David and i recommended.
Just open in designer and save T98 General Ledger Setup - every user will be kicked off the system :whistle: :evil:
Regards,
Slawek
Dynamics NAV, MS SQL Server, Wherescape RED;
PRINCE2 Practitioner - License GR657010572SG
GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-03
And change the object's time? :-k
Thanks a lot. =D>
Its worked with Form but in Code unit is din't work.. ](*,)
Please help
Thanks & regards
Rose
I have modified Code Unit 22,23 Function Code() but it din't reflected my modification to the other user...but in other fuctions it works as you told. #-o
Any idea [-o<
please Help :-k
Thanks & Regards
Rose
So, import the object if nobody is logged on.
YES!
Now please mark this topic as solved.