How to get server and database name from C/SIDE

zyyraf

Hi, what is a best way to get server address and database name of current connection from C/SIDE (database on SQL)?

I found that way:

//svr Record Server
//db Record Database

srv.FINDFIRST;
WHILE NOT srv."My Server" DO
  srv.NEXT;


dbs.FINDFIRST;
WHILE NOT dbs."My Database" DO
  dbs.NEXT;

Message(srv."Server Name");
Message(dbs."Database Name");

The problem is, that this method spend several second.
Anyone know better way to do this?

Shedman

Try using the search ...

Or CONTEXTURL system variable.

garak

These are examples to get the database name / Servername

RecDB.SETRANGE("My Database",TRUE);
RecDB.FINDFIRST;
DBName := RecDB."Database Name";

RecServer.SETRANGE("My Server",TRUE);
RecServer.FINDFIRST;
ServName := RecServer."Server Name";

or

MyContext := CONTEXTURL; 
message('Servername = %1\'+
        'Database = %2',(copystr(MyContext,StrPos(MyContext,'servername') + 11,
                        StrPos(MyContext,'&data') - StrPos(MyContext,'servername')-11)),
                        (copystr(MyContext,StrPos(MyContext,'&data') + 10,
                         StrPos(MyContext,'&company') - StrPos(MyContext,'&data')-10)));

zyyraf

Thank you very much - CONTEXTURL is excellent for my need.

kriki

[Topic moved from Navision forum to Navision Tips & Tricks forum]

Savatage

With this post & other you can get something like this
Sorry for my Old School Menu :oops:

garak

:shock: who are the girls ????

Savatage

We're a Beauty Supplier
3 Hot chicks - anybody got a better logo? 8)

www.CosmeticSolutions.com

http://www.amazon.com/b/105-1417815-454 ... 54EXMVZHXW

garak

for my person, i can't work with "chicks" like these in my firm
... i'm ever distracted =P~ (jammi)