Strange filter behaviour on Table Database

tfranzen

Hi,

I experience a strange behaviour of NAV 4.0 SP3 when using a filter on the virtual table Database.

What I want:
I want to give a message to the user when working in a test-database (The name of the database contains the word TEST in any form)

What I did:
In codeunit 1/LoginStart I declared a local record-variable with subtype Database (2000000048), put a filter on field "My Database" and made a FINDFIRST. I received the correct record and trigger the message. So far so good.

But now there comes the problem: when a "normal" user wants to switch the database and opens the OpenDatabase-Dialogue and makes a lookup to the existing databases only the one he has in access is shown and selectable, any other database is not.

Any ideas of solving this problem with this record are appreciated. In the meantime I use CONTEXTURL to get the database name.

Thanks
Thomas

matttrax

Have a look at the Session table. Filter on My Session = Yes. There is a field for the database name.

I would, however, probably go with a different solution. Once that message is gone it is easy for the user to forget that they are in a test database. Constant visual aides, like a red background or big text that says TEST tend to help the user remember more.

kitik

Constant visual aides, like a red background or big text that says TEST tend to help the user remember more.

How do you do that? Do you edit all forms on the db to add a TextBox with the message?

Salut!

DenSter

I've found that adding the word 'TEST' to all of the menus is an effective way to do this. It takes just a couple of minutes to do it, with no development or testing

kitik

This change affects all companies in the database?
Can you change the menu name for just one company? Is yes how?

Salut!

DenSter

It affects the whole database, all companies. As far as I know there is no way to dynamically add the company name to the menus like that.