I need to be able to check whether or not my current session is a live connection to the server, or a test database (local). Can I query the ServerName? Or the Connection Local Field? A previous solution used a commandline query, but that checks how the session started with the shortcut. If a user connects by some other method or changes the connection mid-session then it appears that commandline does not contain the current connection state.
I think this was mentioned before, but you could change some of the colors on the main menu in the test database to lime green and/or bright pink just so you know what database you in just by looking at the color scheme. Plus it’s easy to do!
It sounds like you just wanted to make sure you are in the right place either test or live. When the eyepopping colors appear even the most untrained employee can notice that something is up!
The CONTEXTURL can tell you the server and database name, which you could parse out. From the help file: CONTEXTURL Use this function to return a context string that defines the current position of the running objects. String:=CONTEXTURL String Data type: text or code Example Here are two examples of a context string: navision://client/run?database=filename&company=companyname navision://client/run?server=servername&company=companyname&servertype=MSSQL Cheers
Thank you Darren. Perfect! Works in 3.70. Doesn’t work in 2.01 - suprise. Anyone know when CONTEXTURL was added?
The CONTEXTURL function was added in 2.65, the transition version from Financials to Attain.