I responded too soon. Thanks anyway.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Mike Anstey
Sent: Friday, January 13, 2012 10:39 AM
To: vantage@yahoogroups.com
Subject: FW: [Vantage] Help with MES BPM
IGNORE!, I should have looked at the whole post.....
From: Mike Anstey
Sent: Friday, January 13, 2012 11:33 AM
To: 'vantage@yahoogroups.com <mailto:%27vantage%40yahoogroups.com> '
Subject: RE: [Vantage] Help with MES BPM
For each ttLaborDtl no-lock, each JobMtl no-lock where
(ttLaborDtl.company =JobMtl.Company
and ttLaborDtl.JobNum =JobMtl.Jobnum
and ttLaborDtl.AssemplySeq = JobMtl.AssemblySeq
and %OprSeq% > JobMtl.RelatedOperation)
I assume that %OprSeq% is from ttLaborDtl? If so you have to replace it
with ttLaborDtl.OprSeq.
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Mike Numbers
Sent: Friday, January 13, 2012 11:27 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Help with MES BPM
By replacing the % with single quote got me by the error in the query,
but
for some reason my query is not working with this field. I can verify
the
parameter OprSeq is the value from the screen. My BPM is supposed to
give
me a message if "more than 0 records" are found in the condition. I
changed
the last part of my logic to
'OprSeq' = JobMtl.RelatedOperation
Then ran the job with an operation having material for the
JobMtl.RelatedOperation and got no error.
Everything seems to look ok to me. Since the new feature I am using is
the
parameter, is there anything different on how a parameter works?
Any ideas?
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
Rob Bucek
Sent: Thursday, January 12, 2012 3:26 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Help with MES BPM
My bad...drop those '%' signs and replace it with single quotes...
Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-0590
FAX: (715)284-4084
[Description: cid:1.234354861@...
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of Mike Numbers
Sent: Thursday, January 12, 2012 2:02 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Help with MES BPM
Yes, I am using a preprocess method. I used the "editor" to create the
file
relationships for ttLaborDtl and JobMtl.
I did find the parameter %oprseq%. When I replaced ttlabordtl.oprseq
with
the parameter, I get an error when I "check query".
Below is my code:
For each ttLaborDtl no-lock, each JobMtl no-lock where
(ttLaborDtl.company =
JobMtl.Company and ttLaborDtl.JobNum =JobMtl.Jobnum and
ttLaborDtl.AssemplySeq = JobMtl.AssemblySeq and %OprSeq% >
JobMtl.RelatedOperation)
The error I am getting is--- %oprseq% must be a quoted constant or an
unabbreviated, unambiguous buffer/field reference for buffers known to
query
(7328).
Any ideas?
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>]
On
Behalf Of
Rob Bucek
Sent: Thursday, January 12, 2012 2:33 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Help with MES BPM
I assume you are using a preprocess, but what is your condition? Are you
using designed query? If you are using ttlabordtl.oprseq you may want to
try
using a parameter instead. Sometimes, on some forms (see the trend?)
vantage
passes values through parameters rather than the temp dataset. If you
right
click in the query builder youll see a parameter option in your context
menu, in this instance youll find %oprSeq%
Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-0590
FAX: (715)284-4084
[Description: cid:1.234354861@...
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ]
On
Behalf Of mike.numbers
Sent: Thursday, January 12, 2012 1:08 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Help with MES BPM
I am trying to write my first BPM for MES. I am trying to verify all
material has been issued before a user can clock into a job operation. I
am
using method Labor.DefaultOprSeq. My problem is when I go to JobMtl my
oprseq from ttLaborDtl is always the previous screen value. For instance
when my screen from Start Production Activity shows Job 050005 Asmy 0
Operation 10, the BPM sees operation 0 when I change the screen to
Operation
20 the BPM sees operation 10. The jobnum comes through correctly.
Any ideas on what I am doing wrong?
[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]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Mike Anstey
Sent: Friday, January 13, 2012 10:39 AM
To: vantage@yahoogroups.com
Subject: FW: [Vantage] Help with MES BPM
IGNORE!, I should have looked at the whole post.....
From: Mike Anstey
Sent: Friday, January 13, 2012 11:33 AM
To: 'vantage@yahoogroups.com <mailto:%27vantage%40yahoogroups.com> '
Subject: RE: [Vantage] Help with MES BPM
For each ttLaborDtl no-lock, each JobMtl no-lock where
(ttLaborDtl.company =JobMtl.Company
and ttLaborDtl.JobNum =JobMtl.Jobnum
and ttLaborDtl.AssemplySeq = JobMtl.AssemblySeq
and %OprSeq% > JobMtl.RelatedOperation)
I assume that %OprSeq% is from ttLaborDtl? If so you have to replace it
with ttLaborDtl.OprSeq.
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Mike Numbers
Sent: Friday, January 13, 2012 11:27 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Help with MES BPM
By replacing the % with single quote got me by the error in the query,
but
for some reason my query is not working with this field. I can verify
the
parameter OprSeq is the value from the screen. My BPM is supposed to
give
me a message if "more than 0 records" are found in the condition. I
changed
the last part of my logic to
'OprSeq' = JobMtl.RelatedOperation
Then ran the job with an operation having material for the
JobMtl.RelatedOperation and got no error.
Everything seems to look ok to me. Since the new feature I am using is
the
parameter, is there anything different on how a parameter works?
Any ideas?
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
Rob Bucek
Sent: Thursday, January 12, 2012 3:26 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Help with MES BPM
My bad...drop those '%' signs and replace it with single quotes...
Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-0590
FAX: (715)284-4084
[Description: cid:1.234354861@...
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of Mike Numbers
Sent: Thursday, January 12, 2012 2:02 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Help with MES BPM
Yes, I am using a preprocess method. I used the "editor" to create the
file
relationships for ttLaborDtl and JobMtl.
I did find the parameter %oprseq%. When I replaced ttlabordtl.oprseq
with
the parameter, I get an error when I "check query".
Below is my code:
For each ttLaborDtl no-lock, each JobMtl no-lock where
(ttLaborDtl.company =
JobMtl.Company and ttLaborDtl.JobNum =JobMtl.Jobnum and
ttLaborDtl.AssemplySeq = JobMtl.AssemblySeq and %OprSeq% >
JobMtl.RelatedOperation)
The error I am getting is--- %oprseq% must be a quoted constant or an
unabbreviated, unambiguous buffer/field reference for buffers known to
query
(7328).
Any ideas?
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>]
On
Behalf Of
Rob Bucek
Sent: Thursday, January 12, 2012 2:33 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Help with MES BPM
I assume you are using a preprocess, but what is your condition? Are you
using designed query? If you are using ttlabordtl.oprseq you may want to
try
using a parameter instead. Sometimes, on some forms (see the trend?)
vantage
passes values through parameters rather than the temp dataset. If you
right
click in the query builder youll see a parameter option in your context
menu, in this instance youll find %oprSeq%
Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-0590
FAX: (715)284-4084
[Description: cid:1.234354861@...
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ]
On
Behalf Of mike.numbers
Sent: Thursday, January 12, 2012 1:08 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Help with MES BPM
I am trying to write my first BPM for MES. I am trying to verify all
material has been issued before a user can clock into a job operation. I
am
using method Labor.DefaultOprSeq. My problem is when I go to JobMtl my
oprseq from ttLaborDtl is always the previous screen value. For instance
when my screen from Start Production Activity shows Job 050005 Asmy 0
Operation 10, the BPM sees operation 0 when I change the screen to
Operation
20 the BPM sees operation 10. The jobnum comes through correctly.
Any ideas on what I am doing wrong?
[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]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]