We al know this blog entry of Waldo. It shows you how you can see what database you are logged onto.
Now with the Role Tailored Client we have the same issue. All these years of R&D at Microsoft and no one had a brigt moment of implementing this.
Off course you can see the companyname very clear. But you also want to see if you are in the testdatabase or production.
Now how did I implement this.
Step 1 - Create a new page
We create a new page. Do not use the wizard and do not choose a sourcetable.
Make sure your page looks like this.
Step 2 - Declare global variables
This page needs two variables, one Text and one record of type 2000000048.
Step 3 - The C/AL Code
Our page needs a little piece of C/AL code
As you see we take in account that not everyone has permissions to see the Database table. A user will get a message when he/she has no permission.
Step 4 - The Text Constant
Step 5 - The Page Properties
Step 6 - Coloring
The coloring is done in the properties of the Databasename field.
Step 7 - Add the page to a role center
To make it work you need to add the page to each role center that needs this functionality
I our case this is rolecenter 9006
And that's it.
Off course you can also add all the stuff from Eric's blog as well.
Download the page including this information here...
As you mentioned, this should be standard NAV and displayed somewhere on the screen.
I agree with you.Something is better than nothing..Nice Trick...
Coincidence ... I'm working on an update of my blogpost .. with a slightly different "solution".
I hope you don't mind that I post it nevertheless?
Anyway, good one!
I am curious to see your solution. ;)
I am sure there are more ways to get the database information. This is just one of them.