Thank you for your reply, Aaron.
I know that Vantage uses global variables and I will do some research on how
Vantage handles its global user id.
Carl
Carl D. Peterson, CPIM
Nexus Software, Inc.
Plymouth, Michigan 48170
1-734-812-9532 - Mobile
1-734-453-3101 - Office
1-734-455-9550 - Fax
cpeterson@...
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Aaron Hoyt
Sent: Tuesday, October 23, 2007 2:45 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Vantage 8.03.400 BAM .P question
Thank you, but it is still pulling the userid of the appserver, not the user
that triggered the BAM.
I have a call into support, but I am not holding my breath at this point.
I just had a thought though. I might be able to get around it by using the
WorkCenter that the employee is working on to determine the information
(This BAM is triggered by the LaborDtl table) I am really looking for the
computer they are using so that I can print a label on their printer. I
might be able to use the workcenter (sorry Resource group) they are
reporting against and print to that printer. It will not handle well when
they are reporting on a different workcenter, but in the long run that might
be a good thing.
I appreciate the help, if I do hear back from Support about how they suggest
handling this, I will be sure to pass it on.
Thanks,
Aaron Hoyt
Vantage Plastics
-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ]On
Behalf Of
Carl Peterson
Sent: Tuesday, October 23, 2007 12:38 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Vantage 8.03.400 BAM .P question
You could try this, Aaron.
Def var vUserid as char format "x(30)" no-undo.
vUserid = userid("Mfgsys").
Find first company no-lock no-error.
Find first UserComp no-lock where usercomp.company =
company.company
And usercomp.DCDUserid = vuserid no-error.
This will give you access to the user's name.
Carl
Carl D. Peterson, CPIM
Nexus Software, Inc.
Plymouth, Michigan 48170
1-734-812-9532 - Mobile
1-734-453-3101 - Office
1-734-455-9550 - Fax
cpeterson@... <mailto:cpeterson%40NexusSoftware.net>
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of
Aaron Hoyt
Sent: Tuesday, October 23, 2007 11:49 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Vantage 8.03.400 BAM .P question
Scott,
Try as I might, I can't figure how to use this table in a .p. Can you
suggest a method to find the correct record from this table?
Thanks,
Aaron Hoyt
Vantage Plastics
-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ]On
Behalf Of
Scott Litzau
Sent: Tuesday, October 23, 2007 11:21 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Vantage 8.03.400 BAM .P question
Aaron,
There is a Table UserComp that holds the Full User Name and User ID. The
fields are Name and DCDUserID.
Scott
-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of
Aaron Hoyt
Sent: Tuesday, October 23, 2007 9:27 AM
To: Vantage Group
Subject: [Vantage] Vantage 8.03.400 BAM .P question
In preparing for the jump from 6.1 to 8.03.400 I have finally learned how
to
fix my BAM .p procedures to allow them to run in 8.X. Unfortunately they
are now running from the server and that leaves me a new challenge. What I
need to know is the Global variables available to the .p running from a
BAM.
Specifically I am looking for the current Vantage UserID. I have
discovered
I can get at the windows UserID using UserID, but I need the Vantage user
that is driving the BAM. Does anyone have any ideas of how to get at this
information?
Thanks,
Aaron Hoyt
Vantage Plastics
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/.
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Links
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
I know that Vantage uses global variables and I will do some research on how
Vantage handles its global user id.
Carl
Carl D. Peterson, CPIM
Nexus Software, Inc.
Plymouth, Michigan 48170
1-734-812-9532 - Mobile
1-734-453-3101 - Office
1-734-455-9550 - Fax
cpeterson@...
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Aaron Hoyt
Sent: Tuesday, October 23, 2007 2:45 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Vantage 8.03.400 BAM .P question
Thank you, but it is still pulling the userid of the appserver, not the user
that triggered the BAM.
I have a call into support, but I am not holding my breath at this point.
I just had a thought though. I might be able to get around it by using the
WorkCenter that the employee is working on to determine the information
(This BAM is triggered by the LaborDtl table) I am really looking for the
computer they are using so that I can print a label on their printer. I
might be able to use the workcenter (sorry Resource group) they are
reporting against and print to that printer. It will not handle well when
they are reporting on a different workcenter, but in the long run that might
be a good thing.
I appreciate the help, if I do hear back from Support about how they suggest
handling this, I will be sure to pass it on.
Thanks,
Aaron Hoyt
Vantage Plastics
-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ]On
Behalf Of
Carl Peterson
Sent: Tuesday, October 23, 2007 12:38 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Vantage 8.03.400 BAM .P question
You could try this, Aaron.
Def var vUserid as char format "x(30)" no-undo.
vUserid = userid("Mfgsys").
Find first company no-lock no-error.
Find first UserComp no-lock where usercomp.company =
company.company
And usercomp.DCDUserid = vuserid no-error.
This will give you access to the user's name.
Carl
Carl D. Peterson, CPIM
Nexus Software, Inc.
Plymouth, Michigan 48170
1-734-812-9532 - Mobile
1-734-453-3101 - Office
1-734-455-9550 - Fax
cpeterson@... <mailto:cpeterson%40NexusSoftware.net>
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of
Aaron Hoyt
Sent: Tuesday, October 23, 2007 11:49 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Vantage 8.03.400 BAM .P question
Scott,
Try as I might, I can't figure how to use this table in a .p. Can you
suggest a method to find the correct record from this table?
Thanks,
Aaron Hoyt
Vantage Plastics
-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ]On
Behalf Of
Scott Litzau
Sent: Tuesday, October 23, 2007 11:21 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Vantage 8.03.400 BAM .P question
Aaron,
There is a Table UserComp that holds the Full User Name and User ID. The
fields are Name and DCDUserID.
Scott
-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of
Aaron Hoyt
Sent: Tuesday, October 23, 2007 9:27 AM
To: Vantage Group
Subject: [Vantage] Vantage 8.03.400 BAM .P question
In preparing for the jump from 6.1 to 8.03.400 I have finally learned how
to
fix my BAM .p procedures to allow them to run in 8.X. Unfortunately they
are now running from the server and that leaves me a new challenge. What I
need to know is the Global variables available to the .p running from a
BAM.
Specifically I am looking for the current Vantage UserID. I have
discovered
I can get at the windows UserID using UserID, but I need the Vantage user
that is driving the BAM. Does anyone have any ideas of how to get at this
information?
Thanks,
Aaron Hoyt
Vantage Plastics
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/.
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Links
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]