Hi,
I am wondering how to recognize the database in Visual Studio Tools, to which the user is logged in. Please help.
The requirement is when the user clicks on a button, the system should push some data to a customized table in respective company database ie., based on the company to which the user is logged in.
Kind Regards,
Renjan
*This post is locked for comments
Hi Renjan,
include:
using Microsoft.Dexterity.Applications;
Reference the following static readonly global settings to get what you need:
// SQL company database name (ie. TWO)
public static readonly string DataBase = Dynamics.Globals.IntercompanyId.Value;
// current user's login
public static readonly string UserID = Dynamics.Globals.UserId.Value;
// references the ODBC name in registry holding the SQL server instance name
public static readonly string DataSource = Dynamics.Globals.SqlDataSourceName.Value;
// company id index
public static readonly short CompanyId = Dynamics.Globals.CompanyId.Value;
// gp date
public static readonly DateTime UserDate = Dynamics.Globals.UserDate.Value;
Hi Angel,
Thank you for the response.
I am actually looking for something similar to 'UserInfoGet.IntercompanyID' (this is being used in VBA) that I can use in VST.
Cheers,
Renjan
Hi Renjan.
You can try this:
SELECT A.USERID, C.CMPNYNAM, C.INTERID
FROM DYNAMICS..SY01500 C
JOIN DYNAMICS..ACTIVITY A
ON C.CMPNYNAM = A.CMPNYNAM
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (