Get Server and Database Name in Role Tailor Client

circlefai

I have search the posts for this solution.
However, in Role tailor Client, CONTEXTURL is not allowed.
In addition, it also cannot open "Server" table and "Database" table.

Please advise on any other suggestion to get the server and database name.
Thank you.

kine

Database name you can get from session table. Server name I do not know now... :-k

garak

Whats with the virtual tables database and server?

Name	DataType	Subtype	Length
RecDB	Record	Database	
RecServer	Record	Server	
ServerName	Text		250
DBName	Text		80

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

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

Are these tables not avail. on RTC?

circlefai

garak wrote:

Whats with the virtual tables database and server?

Name	DataType	Subtype	Length
RecDB	Record	Database	
RecServer	Record	Server	
ServerName	Text		250
DBName	Text		80

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

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

Are these tables not avail. on RTC?

The RTC can only read the table "Database" but not "Server"