Discussions
Activity
Best Of...
Sign In
·
Register
Home
›
NAV/Navision Classic Client
Howdy, Stranger!
It looks like you're new here. Sign in or register to get started.
Sign In
Register
Quick Links
Categories
Recent Discussions
Activity
Best Of...
Unanswered
Categories
All Categories
73
General
73
Announcements
66.6K
Microsoft Dynamics NAV
18.6K
NAV Three Tier
38.4K
NAV/Navision Classic Client
3.6K
Navision Attain
2.4K
Navision Financials
115
Navision DOS
854
Navision e-Commerce
1K
NAV Tips & Tricks
772
NAV Dutch speaking only
615
NAV Courses, Exams & Certification
2K
Microsoft Dynamics-Other
1.5K
Dynamics AX
295
Dynamics CRM
109
Dynamics GP
10
Dynamics SL
1.5K
Other
993
SQL General
384
SQL Performance
34
SQL Tips & Tricks
34
Design Patterns (General & Best Practices)
Architectural Patterns
10
Design Patterns
5
Implementation Patterns
53
3rd Party Products, Services & Events
1.7K
General
1.1K
General Chat
1.6K
Website
79
Testing
1.2K
Download section
23
How Tos section
259
Feedback
12
NAV TechDays 2013 Sessions
13
NAV TechDays 2012 Sessions
ServerName and DataBase name
Hanen
Member
Posts:
281
2009-08-12
edited 2009-08-17
in
NAV/Navision Classic Client
Hi,
i need to retrieve the name of the current server and the connected database name using C/AL.
thnx
Regards
Hanen TALBI
0
Comments
Savatage
Member
Posts:
7,142
2009-08-12
http://www.mibuso.com/howtoinfo.asp?FileID=2
Did you search the forum for
Servername
?
search.php
Also searching for
CONTEXTURL
(select message text only) will provide multiple posts.
Harry Ruiz
http://www.BiloBeauty.com
http://www.autismspeaks.org
0
garak
Member
Posts:
3,263
2009-08-12
viewtopic.php?f=5&t=27548
For the future. first use the search function ;-)
Regards and welcome
Do you make it right, it works too!
0
Hanen
Member
Posts:
281
2009-08-13
Hi,
thnx garak for your reply, this code retrieve the server and database name :
Context := CONTEXTURL;
ServerName := COPYSTR(Context,STRPOS(Context,'servername=')+11); // Delete the "prefix"
ServerName := DELSTR(ServerName,STRPOS(ServerName,'&')); // Delete trailing p.
DatabaseName := COPYSTR(Context,STRPOS(Context,'database=')+9); // -do-
DatabaseName := DELSTR(DatabaseName,STRPOS(DatabaseName,'&')); // -do-
Regards
Hanen TALBI
0
garak
Member
Posts:
3,263
2009-08-13
you're welcome
Do you make it right, it works too!
0
kriki
Member, Moderator
Posts:
9,110
2009-08-17
[Topic moved from 'NAV Tips & Tricks' forum to 'NAV/Navision' forum]
Regards,Alain Krikilion
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
0
Sign In
or
Register
to comment.
Comments
Did you search the forum for Servername?
search.php
Also searching for CONTEXTURL (select message text only) will provide multiple posts.
http://www.BiloBeauty.com
http://www.autismspeaks.org
For the future. first use the search function ;-)
Regards and welcome
thnx garak for your reply, this code retrieve the server and database name :
Context := CONTEXTURL;
ServerName := COPYSTR(Context,STRPOS(Context,'servername=')+11); // Delete the "prefix"
ServerName := DELSTR(ServerName,STRPOS(ServerName,'&')); // Delete trailing p.
DatabaseName := COPYSTR(Context,STRPOS(Context,'database=')+9); // -do-
DatabaseName := DELSTR(DatabaseName,STRPOS(DatabaseName,'&')); // -do-
Hanen TALBI
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!