Current Active Company

If you eliminate the first table (_MyConnection) and start with the _Connect table you can create a list of all users and their PID. If you know a specific user name you can filter for just it and be able to find their current company. If the Vantage username and the Windows login username are the same then you ought to be able to do some sort of call to WIndows to get the windows username of who is running the report. Sorry this is not complete but this is the direction I would pursue if I were trying to do this.

-Todd C.

-----Original Message-----
From: cwong_thinktech [mailto:cwong@...]
Sent: Thursday, November 20, 2003 7:48 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Current Active Company


Dear All,

Yestoday, I read some mails about how to get current active company. The
detail is as follows:

The tables and links are:
Table Links
_MyConnection Link to Connect table using PID field
Connect Link to UserFile using _Connect-Name to DCDUserID
UserFile Link to desired master data table for report
using CurComp to Company field

Looking at this linkage, the KEY to get current active company is user's
Progress PID. Then how can we get the progress PID for each vantage user?
Is it stored somewhere ? Is it store in a log file on each progress/vantage
client workstation?

How can we get the progress PID for each vantage user? Do we need to create a
progress store procedure in progress database to get the PID? If so, how
should the store procedure/program look like?

Can anyone advise me?

Christine Wong
--
Webmail



Yahoo! Groups Sponsor

ADVERTISEMENT
<http://rd.yahoo.com/SIG=12ctfnogv/M=267637.4116732.5333197.1261774/D=egroupweb/S=1705007183:HM/EXP=1069465612/A=1853618/R=0/*http://www.netflix.com/Default?mqso=60178338&partid=4116732> click here
<http://us.adserver.yahoo.com/l?M=267637.4116732.5333197.1261774/D=egroupmail/S=:HM/A=1853618/rand=264918426>

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
Dear All,

Our customer ask our company to develop
external program to read the current active company of Vantage. Therefore,
my question is: how to read the current active company of vantage by
external program? for example, Access programming, or Visual Basic
programming?


Christine


--
Webmail
Dear All,

Yestoday, I read some mails about how to get current active company. The
detail is as follows:

The tables and links are:
Table Links
_MyConnection Link to Connect table using PID field
Connect Link to UserFile using _Connect-Name to DCDUserID
UserFile Link to desired master data table for report
using CurComp to Company field

Looking at this linkage, the KEY to get current active company is user's
Progress PID. Then how can we get the progress PID for each vantage user?
Is it stored somewhere ? Is it store in a log file on each progress/vantage
client workstation?

How can we get the progress PID for each vantage user? Do we need to create a
progress store procedure in progress database to get the PID? If so, how
should the store procedure/program look like?

Can anyone advise me?

Christine Wong
--
Webmail