Mass lock qty on Jobs

I might be able to help. In vantage 406 there a two fields pointing to the same thing. JobHead.LockedQty and JobHead.LockQty. Now, when I installed 409, JobHead.LockedQty has been removed and you are only left with JobHead.LockQty. I now have a working BPM that locks the qty of all new jobs.



--- In vantage@yahoogroups.com, "LakeIT" <inthespot1@...> wrote:
>
>
>
> We are currently experiencing a related issue. We would like to create a simple report to show what jobs have the Qty locked and what jobs do not. If we look in the customizaiton screen it shows the Qty Lock checkbox being saved in JobHead.LockedQty, but we cannot see that field in our JobHead Table.
>
> I have looked through the replies to your post and that ttJobHead is being referenced but I do not see that table in our DB.
>
> Our MRP is using the locked QTY field correctly, but we cannot seem to find it to report off of it.
>
> Any help would be appreciated.
>
Hello,

I need to mass lock the qty on all open jobs.

I created a BPM on the JobEntry\GetNewJobHead method.

On the condition (pre processing) I added:

the Jobhead.JobClosed field of all rows is equal to the FALSE value

Then on the Actions I created:

set the JobHead.LockedQty field of all rows to the TRUE value

I also put the above action in the post processing as well.

I went into job entry, created a test job and presto the Locked Qty is ticked, however, all the other jobs still have the locked qty unticked - how do I do this for all Jobs??

Thanks for any help

Michael Hutcheson
I created a preprocessing action on the Job Entry update.

action is to execute 4 gl code:

find first ttjobhead no-lock no-error.

if available ttjobhead.jobclosed = 'FALSE' then do:

ttjobhead.LockedQty = 'TRUE'

End


However, I keep receiving the following error:

Error Detail
============
Unknown database name ttjobhead. (855)
Unknown or ambiguous table jobclosed. (725)
** Could not understand line 23. (198)

Any ideas?

Michael.

--- In vantage@yahoogroups.com, "michael.hutcheson@..." <michael.hutcheson@...> wrote:
>
> Hello,
>
> I need to mass lock the qty on all open jobs.
>
> I created a BPM on the JobEntry\GetNewJobHead method.
>
> On the condition (pre processing) I added:
>
> the Jobhead.JobClosed field of all rows is equal to the FALSE value
>
> Then on the Actions I created:
>
> set the JobHead.LockedQty field of all rows to the TRUE value
>
> I also put the above action in the post processing as well.
>
> I went into job entry, created a test job and presto the Locked Qty is ticked, however, all the other jobs still have the locked qty unticked - how do I do this for all Jobs??
>
> Thanks for any help
>
> Michael Hutcheson
>
Try

if ttjobhead.JobClosed = 'FALSE' then do:

I think the AVAILABLE keyword is what is blowing it up

--- In vantage@yahoogroups.com, "michael.hutcheson@..." <michael.hutcheson@...> wrote:
>
> I created a preprocessing action on the Job Entry update.
>
> action is to execute 4 gl code:
>
> find first ttjobhead no-lock no-error.
>
> if available ttjobhead.jobclosed = 'FALSE' then do:
>
> ttjobhead.LockedQty = 'TRUE'
>
> End
>
>
> However, I keep receiving the following error:
>
> Error Detail
> ============
> Unknown database name ttjobhead. (855)
> Unknown or ambiguous table jobclosed. (725)
> ** Could not understand line 23. (198)
>
> Any ideas?
>
> Michael.
>
> --- In vantage@yahoogroups.com, "michael.hutcheson@" <michael.hutcheson@> wrote:
> >
> > Hello,
> >
> > I need to mass lock the qty on all open jobs.
> >
> > I created a BPM on the JobEntry\GetNewJobHead method.
> >
> > On the condition (pre processing) I added:
> >
> > the Jobhead.JobClosed field of all rows is equal to the FALSE value
> >
> > Then on the Actions I created:
> >
> > set the JobHead.LockedQty field of all rows to the TRUE value
> >
> > I also put the above action in the post processing as well.
> >
> > I went into job entry, created a test job and presto the Locked Qty is ticked, however, all the other jobs still have the locked qty unticked - how do I do this for all Jobs??
> >
> > Thanks for any help
> >
> > Michael Hutcheson
> >
>
Hello,

I tried:

find first ttjobhead where ttjobhead.rowmod = 'A' or ttjobhead.rowmod = 'U' no-error.
if ttjobhead.jobclosed = 'False' then do:
assign ttjobhead.lockedqty = 'TRUE'
End

But got:

Error Detail
============
** Incompatible data types in expression or assignment. (223)
** Could not understand line 22. (198)


Also tried:

find first ttjobhead where ttjobhead.rowmod = 'A' or ttjobhead.rowmod = 'U' and ttjobhead.jobclosed = 'FALSE' no-error.
if available ttjobhead then do:
assign ttjobhead.lockedqty = 'TRUE'
End

But got:

Error Detail
============
** Incompatible data types in expression or assignment. (223)
** Could not understand line 21. (196)

Michael

--- In vantage@yahoogroups.com, "bw2868bond" <bwalker@...> wrote:
>
> Try
>
> if ttjobhead.JobClosed = 'FALSE' then do:
>
> I think the AVAILABLE keyword is what is blowing it up
>
> --- In vantage@yahoogroups.com, "michael.hutcheson@" <michael.hutcheson@> wrote:
> >
> > I created a preprocessing action on the Job Entry update.
> >
> > action is to execute 4 gl code:
> >
> > find first ttjobhead no-lock no-error.
> >
> > if available ttjobhead.jobclosed = 'FALSE' then do:
> >
> > ttjobhead.LockedQty = 'TRUE'
> >
> > End
> >
> >
> > However, I keep receiving the following error:
> >
> > Error Detail
> > ============
> > Unknown database name ttjobhead. (855)
> > Unknown or ambiguous table jobclosed. (725)
> > ** Could not understand line 23. (198)
> >
> > Any ideas?
> >
> > Michael.
> >
> > --- In vantage@yahoogroups.com, "michael.hutcheson@" <michael.hutcheson@> wrote:
> > >
> > > Hello,
> > >
> > > I need to mass lock the qty on all open jobs.
> > >
> > > I created a BPM on the JobEntry\GetNewJobHead method.
> > >
> > > On the condition (pre processing) I added:
> > >
> > > the Jobhead.JobClosed field of all rows is equal to the FALSE value
> > >
> > > Then on the Actions I created:
> > >
> > > set the JobHead.LockedQty field of all rows to the TRUE value
> > >
> > > I also put the above action in the post processing as well.
> > >
> > > I went into job entry, created a test job and presto the Locked Qty is ticked, however, all the other jobs still have the locked qty unticked - how do I do this for all Jobs??
> > >
> > > Thanks for any help
> > >
> > > Michael Hutcheson
> > >
> >
>
tried this:

find first ttjobhead where ttjobhead.rowmod = 'A' or ttjobhead.rowmod = 'U' no-error.
if available ttjobhead then do:
find first job where ttjobhead.JobClosed = 'FALSE' no-lock no-error
if not available job then return
if available then do:
assign ttjobhead.lockedqty = 'TRUE'
end
end


but got this:
The following application error was encountered:

** Line 24. Colon followed by white space terminates a statement. (199)





--- In vantage@yahoogroups.com, "bw2868bond" <bwalker@...> wrote:
>
> Try
>
> if ttjobhead.JobClosed = 'FALSE' then do:
>
> I think the AVAILABLE keyword is what is blowing it up
>
> --- In vantage@yahoogroups.com, "michael.hutcheson@" <michael.hutcheson@> wrote:
> >
> > I created a preprocessing action on the Job Entry update.
> >
> > action is to execute 4 gl code:
> >
> > find first ttjobhead no-lock no-error.
> >
> > if available ttjobhead.jobclosed = 'FALSE' then do:
> >
> > ttjobhead.LockedQty = 'TRUE'
> >
> > End
> >
> >
> > However, I keep receiving the following error:
> >
> > Error Detail
> > ============
> > Unknown database name ttjobhead. (855)
> > Unknown or ambiguous table jobclosed. (725)
> > ** Could not understand line 23. (198)
> >
> > Any ideas?
> >
> > Michael.
> >
> > --- In vantage@yahoogroups.com, "michael.hutcheson@" <michael.hutcheson@> wrote:
> > >
> > > Hello,
> > >
> > > I need to mass lock the qty on all open jobs.
> > >
> > > I created a BPM on the JobEntry\GetNewJobHead method.
> > >
> > > On the condition (pre processing) I added:
> > >
> > > the Jobhead.JobClosed field of all rows is equal to the FALSE value
> > >
> > > Then on the Actions I created:
> > >
> > > set the JobHead.LockedQty field of all rows to the TRUE value
> > >
> > > I also put the above action in the post processing as well.
> > >
> > > I went into job entry, created a test job and presto the Locked Qty is ticked, however, all the other jobs still have the locked qty unticked - how do I do this for all Jobs??
> > >
> > > Thanks for any help
> > >
> > > Michael Hutcheson
> > >
> >
>
Hi,



Try removing the quotes around False and True.



Linda



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of michael.hutcheson@...
Sent: Thursday, November 26, 2009 8:17 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Mass lock qty on Jobs





Hello,

I tried:

find first ttjobhead where ttjobhead.rowmod = 'A' or ttjobhead.rowmod =
'U' no-error.
if ttjobhead.jobclosed = 'False' then do:
assign ttjobhead.lockedqty = 'TRUE'
End

But got:

Error Detail
============
** Incompatible data types in expression or assignment. (223)
** Could not understand line 22. (198)

Also tried:

find first ttjobhead where ttjobhead.rowmod = 'A' or ttjobhead.rowmod =
'U' and ttjobhead.jobclosed = 'FALSE' no-error.
if available ttjobhead then do:
assign ttjobhead.lockedqty = 'TRUE'
End

But got:

Error Detail
============
** Incompatible data types in expression or assignment. (223)
** Could not understand line 21. (196)

Michael

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"bw2868bond" <bwalker@...> wrote:
>
> Try
>
> if ttjobhead.JobClosed = 'FALSE' then do:
>
> I think the AVAILABLE keyword is what is blowing it up
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"michael.hutcheson@" <michael.hutcheson@> wrote:
> >
> > I created a preprocessing action on the Job Entry update.
> >
> > action is to execute 4 gl code:
> >
> > find first ttjobhead no-lock no-error.
> >
> > if available ttjobhead.jobclosed = 'FALSE' then do:
> >
> > ttjobhead.LockedQty = 'TRUE'
> >
> > End
> >
> >
> > However, I keep receiving the following error:
> >
> > Error Detail
> > ============
> > Unknown database name ttjobhead. (855)
> > Unknown or ambiguous table jobclosed. (725)
> > ** Could not understand line 23. (198)
> >
> > Any ideas?
> >
> > Michael.
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"michael.hutcheson@" <michael.hutcheson@> wrote:
> > >
> > > Hello,
> > >
> > > I need to mass lock the qty on all open jobs.
> > >
> > > I created a BPM on the JobEntry\GetNewJobHead method.
> > >
> > > On the condition (pre processing) I added:
> > >
> > > the Jobhead.JobClosed field of all rows is equal to the FALSE
value
> > >
> > > Then on the Actions I created:
> > >
> > > set the JobHead.LockedQty field of all rows to the TRUE value
> > >
> > > I also put the above action in the post processing as well.
> > >
> > > I went into job entry, created a test job and presto the Locked
Qty is ticked, however, all the other jobs still have the locked qty
unticked - how do I do this for all Jobs??
> > >
> > > Thanks for any help
> > >
> > > Michael Hutcheson
> > >
> >
>





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

Tried this:

For each ttjobhead where ttjobhead.RowMod = 'A' or ttjobhead.RowMod = 'U' and ttjobhead.LockedQty = 'False' no-lock:
If available ttJobhead then do:
Run lib\UpdateTableBuffer.p(input BUFFER ttJobHead:HANDLE,'LockedQty',True).
End.

But received:

Error Detail
============
** Incompatible data types in expression or assignment. (223)
** Could not understand line 21. (196)

Think its going to be a process of elimination!!

Michael




--- In vantage@yahoogroups.com, "Linda Lowney" <llowney@...> wrote:
>
> Hi,
>
>
>
> Try removing the quotes around False and True.
>
>
>
> Linda
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of michael.hutcheson@...
> Sent: Thursday, November 26, 2009 8:17 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Mass lock qty on Jobs
>
>
>
>
>
> Hello,
>
> I tried:
>
> find first ttjobhead where ttjobhead.rowmod = 'A' or ttjobhead.rowmod =
> 'U' no-error.
> if ttjobhead.jobclosed = 'False' then do:
> assign ttjobhead.lockedqty = 'TRUE'
> End
>
> But got:
>
> Error Detail
> ============
> ** Incompatible data types in expression or assignment. (223)
> ** Could not understand line 22. (198)
>
> Also tried:
>
> find first ttjobhead where ttjobhead.rowmod = 'A' or ttjobhead.rowmod =
> 'U' and ttjobhead.jobclosed = 'FALSE' no-error.
> if available ttjobhead then do:
> assign ttjobhead.lockedqty = 'TRUE'
> End
>
> But got:
>
> Error Detail
> ============
> ** Incompatible data types in expression or assignment. (223)
> ** Could not understand line 21. (196)
>
> Michael
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "bw2868bond" <bwalker@> wrote:
> >
> > Try
> >
> > if ttjobhead.JobClosed = 'FALSE' then do:
> >
> > I think the AVAILABLE keyword is what is blowing it up
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "michael.hutcheson@" <michael.hutcheson@> wrote:
> > >
> > > I created a preprocessing action on the Job Entry update.
> > >
> > > action is to execute 4 gl code:
> > >
> > > find first ttjobhead no-lock no-error.
> > >
> > > if available ttjobhead.jobclosed = 'FALSE' then do:
> > >
> > > ttjobhead.LockedQty = 'TRUE'
> > >
> > > End
> > >
> > >
> > > However, I keep receiving the following error:
> > >
> > > Error Detail
> > > ============
> > > Unknown database name ttjobhead. (855)
> > > Unknown or ambiguous table jobclosed. (725)
> > > ** Could not understand line 23. (198)
> > >
> > > Any ideas?
> > >
> > > Michael.
> > >
> > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "michael.hutcheson@" <michael.hutcheson@> wrote:
> > > >
> > > > Hello,
> > > >
> > > > I need to mass lock the qty on all open jobs.
> > > >
> > > > I created a BPM on the JobEntry\GetNewJobHead method.
> > > >
> > > > On the condition (pre processing) I added:
> > > >
> > > > the Jobhead.JobClosed field of all rows is equal to the FALSE
> value
> > > >
> > > > Then on the Actions I created:
> > > >
> > > > set the JobHead.LockedQty field of all rows to the TRUE value
> > > >
> > > > I also put the above action in the post processing as well.
> > > >
> > > > I went into job entry, created a test job and presto the Locked
> Qty is ticked, however, all the other jobs still have the locked qty
> unticked - how do I do this for all Jobs??
> > > >
> > > > Thanks for any help
> > > >
> > > > Michael Hutcheson
> > > >
> > >
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
Sorry, should be:

For each ttjobhead where ttjobhead.RowMod = 'A' or ttjobhead.RowMod = 'U' and ttjobhead.JobClosed = 'False' no-lock:
If available ttJobhead then do:
Run lib\UpdateTableBuffer.p(input BUFFER ttJobHead:HANDLE,'LockedQty',True).
End.

Still not working though

--- In vantage@yahoogroups.com, "michael.hutcheson@..." <michael.hutcheson@...> wrote:
>
> Hello,
>
> Tried this:
>
> For each ttjobhead where ttjobhead.RowMod = 'A' or ttjobhead.RowMod = 'U' and ttjobhead.LockedQty = 'False' no-lock:
> If available ttJobhead then do:
> Run lib\UpdateTableBuffer.p(input BUFFER ttJobHead:HANDLE,'LockedQty',True).
> End.
>
> But received:
>
> Error Detail
> ============
> ** Incompatible data types in expression or assignment. (223)
> ** Could not understand line 21. (196)
>
> Think its going to be a process of elimination!!
>
> Michael
>
>
>
>
> --- In vantage@yahoogroups.com, "Linda Lowney" <llowney@> wrote:
> >
> > Hi,
> >
> >
> >
> > Try removing the quotes around False and True.
> >
> >
> >
> > Linda
> >
> >
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> > Of michael.hutcheson@
> > Sent: Thursday, November 26, 2009 8:17 AM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Re: Mass lock qty on Jobs
> >
> >
> >
> >
> >
> > Hello,
> >
> > I tried:
> >
> > find first ttjobhead where ttjobhead.rowmod = 'A' or ttjobhead.rowmod =
> > 'U' no-error.
> > if ttjobhead.jobclosed = 'False' then do:
> > assign ttjobhead.lockedqty = 'TRUE'
> > End
> >
> > But got:
> >
> > Error Detail
> > ============
> > ** Incompatible data types in expression or assignment. (223)
> > ** Could not understand line 22. (198)
> >
> > Also tried:
> >
> > find first ttjobhead where ttjobhead.rowmod = 'A' or ttjobhead.rowmod =
> > 'U' and ttjobhead.jobclosed = 'FALSE' no-error.
> > if available ttjobhead then do:
> > assign ttjobhead.lockedqty = 'TRUE'
> > End
> >
> > But got:
> >
> > Error Detail
> > ============
> > ** Incompatible data types in expression or assignment. (223)
> > ** Could not understand line 21. (196)
> >
> > Michael
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> > "bw2868bond" <bwalker@> wrote:
> > >
> > > Try
> > >
> > > if ttjobhead.JobClosed = 'FALSE' then do:
> > >
> > > I think the AVAILABLE keyword is what is blowing it up
> > >
> > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> > "michael.hutcheson@" <michael.hutcheson@> wrote:
> > > >
> > > > I created a preprocessing action on the Job Entry update.
> > > >
> > > > action is to execute 4 gl code:
> > > >
> > > > find first ttjobhead no-lock no-error.
> > > >
> > > > if available ttjobhead.jobclosed = 'FALSE' then do:
> > > >
> > > > ttjobhead.LockedQty = 'TRUE'
> > > >
> > > > End
> > > >
> > > >
> > > > However, I keep receiving the following error:
> > > >
> > > > Error Detail
> > > > ============
> > > > Unknown database name ttjobhead. (855)
> > > > Unknown or ambiguous table jobclosed. (725)
> > > > ** Could not understand line 23. (198)
> > > >
> > > > Any ideas?
> > > >
> > > > Michael.
> > > >
> > > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> > "michael.hutcheson@" <michael.hutcheson@> wrote:
> > > > >
> > > > > Hello,
> > > > >
> > > > > I need to mass lock the qty on all open jobs.
> > > > >
> > > > > I created a BPM on the JobEntry\GetNewJobHead method.
> > > > >
> > > > > On the condition (pre processing) I added:
> > > > >
> > > > > the Jobhead.JobClosed field of all rows is equal to the FALSE
> > value
> > > > >
> > > > > Then on the Actions I created:
> > > > >
> > > > > set the JobHead.LockedQty field of all rows to the TRUE value
> > > > >
> > > > > I also put the above action in the post processing as well.
> > > > >
> > > > > I went into job entry, created a test job and presto the Locked
> > Qty is ticked, however, all the other jobs still have the locked qty
> > unticked - how do I do this for all Jobs??
> > > > >
> > > > > Thanks for any help
> > > > >
> > > > > Michael Hutcheson
> > > > >
> > > >
> > >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
Did you try removing the quotes around False ---- ttJobHead.JobClosed =
False no-lock:



Linda



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of michael.hutcheson@...
Sent: Thursday, November 26, 2009 9:36 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Mass lock qty on Jobs





Sorry, should be:

For each ttjobhead where ttjobhead.RowMod = 'A' or ttjobhead.RowMod =
'U' and ttjobhead.JobClosed = 'False' no-lock:
If available ttJobhead then do:
Run lib\UpdateTableBuffer.p(input BUFFER
ttJobHead:HANDLE,'LockedQty',True).
End.

Still not working though

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"michael.hutcheson@..." <michael.hutcheson@...> wrote:
>
> Hello,
>
> Tried this:
>
> For each ttjobhead where ttjobhead.RowMod = 'A' or ttjobhead.RowMod =
'U' and ttjobhead.LockedQty = 'False' no-lock:
> If available ttJobhead then do:
> Run lib\UpdateTableBuffer.p(input BUFFER
ttJobHead:HANDLE,'LockedQty',True).
> End.
>
> But received:
>
> Error Detail
> ============
> ** Incompatible data types in expression or assignment. (223)
> ** Could not understand line 21. (196)
>
> Think its going to be a process of elimination!!
>
> Michael
>
>
>
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Linda Lowney" <llowney@> wrote:
> >
> > Hi,
> >
> >
> >
> > Try removing the quotes around False and True.
> >
> >
> >
> > Linda
> >
> >
> >
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
> > Of michael.hutcheson@
> > Sent: Thursday, November 26, 2009 8:17 AM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Re: Mass lock qty on Jobs
> >
> >
> >
> >
> >
> > Hello,
> >
> > I tried:
> >
> > find first ttjobhead where ttjobhead.rowmod = 'A' or
ttjobhead.rowmod =
> > 'U' no-error.
> > if ttjobhead.jobclosed = 'False' then do:
> > assign ttjobhead.lockedqty = 'TRUE'
> > End
> >
> > But got:
> >
> > Error Detail
> > ============
> > ** Incompatible data types in expression or assignment. (223)
> > ** Could not understand line 22. (198)
> >
> > Also tried:
> >
> > find first ttjobhead where ttjobhead.rowmod = 'A' or
ttjobhead.rowmod =
> > 'U' and ttjobhead.jobclosed = 'FALSE' no-error.
> > if available ttjobhead then do:
> > assign ttjobhead.lockedqty = 'TRUE'
> > End
> >
> > But got:
> >
> > Error Detail
> > ============
> > ** Incompatible data types in expression or assignment. (223)
> > ** Could not understand line 21. (196)
> >
> > Michael
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ,
> > "bw2868bond" <bwalker@> wrote:
> > >
> > > Try
> > >
> > > if ttjobhead.JobClosed = 'FALSE' then do:
> > >
> > > I think the AVAILABLE keyword is what is blowing it up
> > >
> > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ,
> > "michael.hutcheson@" <michael.hutcheson@> wrote:
> > > >
> > > > I created a preprocessing action on the Job Entry update.
> > > >
> > > > action is to execute 4 gl code:
> > > >
> > > > find first ttjobhead no-lock no-error.
> > > >
> > > > if available ttjobhead.jobclosed = 'FALSE' then do:
> > > >
> > > > ttjobhead.LockedQty = 'TRUE'
> > > >
> > > > End
> > > >
> > > >
> > > > However, I keep receiving the following error:
> > > >
> > > > Error Detail
> > > > ============
> > > > Unknown database name ttjobhead. (855)
> > > > Unknown or ambiguous table jobclosed. (725)
> > > > ** Could not understand line 23. (198)
> > > >
> > > > Any ideas?
> > > >
> > > > Michael.
> > > >
> > > > --- In vantage@yahoogroups.com
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ,
> > "michael.hutcheson@" <michael.hutcheson@> wrote:
> > > > >
> > > > > Hello,
> > > > >
> > > > > I need to mass lock the qty on all open jobs.
> > > > >
> > > > > I created a BPM on the JobEntry\GetNewJobHead method.
> > > > >
> > > > > On the condition (pre processing) I added:
> > > > >
> > > > > the Jobhead.JobClosed field of all rows is equal to the FALSE
> > value
> > > > >
> > > > > Then on the Actions I created:
> > > > >
> > > > > set the JobHead.LockedQty field of all rows to the TRUE value
> > > > >
> > > > > I also put the above action in the post processing as well.
> > > > >
> > > > > I went into job entry, created a test job and presto the
Locked
> > Qty is ticked, however, all the other jobs still have the locked qty
> > unticked - how do I do this for all Jobs??
> > > > >
> > > > > Thanks for any help
> > > > >
> > > > > Michael Hutcheson
> > > > >
> > > >
> > >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>





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

I tried this:

for each JobhHead where JobHead.JobClosed = FALSE no-lock:
if available JobHead then do:
Run lib\UpdateTableBuffer.p(input BUFFER JobHead:HANDLE, 'LockedQty',True).
End.
End

But receive this:
Error Detail
============
Unknown or ambiguous table JobhHead. (725)
** Could not understand line 21. (196)

Michael

--- In vantage@yahoogroups.com, "Linda Lowney" <llowney@...> wrote:
>
> Did you try removing the quotes around False ---- ttJobHead.JobClosed =
> False no-lock:
>
>
>
> Linda
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of michael.hutcheson@...
> Sent: Thursday, November 26, 2009 9:36 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Mass lock qty on Jobs
>
>
>
>
>
> Sorry, should be:
>
> For each ttjobhead where ttjobhead.RowMod = 'A' or ttjobhead.RowMod =
> 'U' and ttjobhead.JobClosed = 'False' no-lock:
> If available ttJobhead then do:
> Run lib\UpdateTableBuffer.p(input BUFFER
> ttJobHead:HANDLE,'LockedQty',True).
> End.
>
> Still not working though
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "michael.hutcheson@" <michael.hutcheson@> wrote:
> >
> > Hello,
> >
> > Tried this:
> >
> > For each ttjobhead where ttjobhead.RowMod = 'A' or ttjobhead.RowMod =
> 'U' and ttjobhead.LockedQty = 'False' no-lock:
> > If available ttJobhead then do:
> > Run lib\UpdateTableBuffer.p(input BUFFER
> ttJobHead:HANDLE,'LockedQty',True).
> > End.
> >
> > But received:
> >
> > Error Detail
> > ============
> > ** Incompatible data types in expression or assignment. (223)
> > ** Could not understand line 21. (196)
> >
> > Think its going to be a process of elimination!!
> >
> > Michael
> >
> >
> >
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "Linda Lowney" <llowney@> wrote:
> > >
> > > Hi,
> > >
> > >
> > >
> > > Try removing the quotes around False and True.
> > >
> > >
> > >
> > > Linda
> > >
> > >
> > >
> > > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> Behalf
> > > Of michael.hutcheson@
> > > Sent: Thursday, November 26, 2009 8:17 AM
> > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > Subject: [Vantage] Re: Mass lock qty on Jobs
> > >
> > >
> > >
> > >
> > >
> > > Hello,
> > >
> > > I tried:
> > >
> > > find first ttjobhead where ttjobhead.rowmod = 'A' or
> ttjobhead.rowmod =
> > > 'U' no-error.
> > > if ttjobhead.jobclosed = 'False' then do:
> > > assign ttjobhead.lockedqty = 'TRUE'
> > > End
> > >
> > > But got:
> > >
> > > Error Detail
> > > ============
> > > ** Incompatible data types in expression or assignment. (223)
> > > ** Could not understand line 22. (198)
> > >
> > > Also tried:
> > >
> > > find first ttjobhead where ttjobhead.rowmod = 'A' or
> ttjobhead.rowmod =
> > > 'U' and ttjobhead.jobclosed = 'FALSE' no-error.
> > > if available ttjobhead then do:
> > > assign ttjobhead.lockedqty = 'TRUE'
> > > End
> > >
> > > But got:
> > >
> > > Error Detail
> > > ============
> > > ** Incompatible data types in expression or assignment. (223)
> > > ** Could not understand line 21. (196)
> > >
> > > Michael
> > >
> > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com> ,
> > > "bw2868bond" <bwalker@> wrote:
> > > >
> > > > Try
> > > >
> > > > if ttjobhead.JobClosed = 'FALSE' then do:
> > > >
> > > > I think the AVAILABLE keyword is what is blowing it up
> > > >
> > > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com> ,
> > > "michael.hutcheson@" <michael.hutcheson@> wrote:
> > > > >
> > > > > I created a preprocessing action on the Job Entry update.
> > > > >
> > > > > action is to execute 4 gl code:
> > > > >
> > > > > find first ttjobhead no-lock no-error.
> > > > >
> > > > > if available ttjobhead.jobclosed = 'FALSE' then do:
> > > > >
> > > > > ttjobhead.LockedQty = 'TRUE'
> > > > >
> > > > > End
> > > > >
> > > > >
> > > > > However, I keep receiving the following error:
> > > > >
> > > > > Error Detail
> > > > > ============
> > > > > Unknown database name ttjobhead. (855)
> > > > > Unknown or ambiguous table jobclosed. (725)
> > > > > ** Could not understand line 23. (198)
> > > > >
> > > > > Any ideas?
> > > > >
> > > > > Michael.
> > > > >
> > > > > --- In vantage@yahoogroups.com
> <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ,
> > > "michael.hutcheson@" <michael.hutcheson@> wrote:
> > > > > >
> > > > > > Hello,
> > > > > >
> > > > > > I need to mass lock the qty on all open jobs.
> > > > > >
> > > > > > I created a BPM on the JobEntry\GetNewJobHead method.
> > > > > >
> > > > > > On the condition (pre processing) I added:
> > > > > >
> > > > > > the Jobhead.JobClosed field of all rows is equal to the FALSE
> > > value
> > > > > >
> > > > > > Then on the Actions I created:
> > > > > >
> > > > > > set the JobHead.LockedQty field of all rows to the TRUE value
> > > > > >
> > > > > > I also put the above action in the post processing as well.
> > > > > >
> > > > > > I went into job entry, created a test job and presto the
> Locked
> > > Qty is ticked, however, all the other jobs still have the locked qty
> > > unticked - how do I do this for all Jobs??
> > > > > >
> > > > > > Thanks for any help
> > > > > >
> > > > > > Michael Hutcheson
> > > > > >
> > > > >
> > > >
> > >
> > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
Hi



Unknown or ambiguous table JobhHead. (725) - it looks like you have an
extra "h" in JobHead.



Linda





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of michael.hutcheson@...
Sent: Thursday, November 26, 2009 9:57 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Mass lock qty on Jobs





Yeah,

I tried this:

for each JobhHead where JobHead.JobClosed = FALSE no-lock:
if available JobHead then do:
Run lib\UpdateTableBuffer.p(input BUFFER JobHead:HANDLE,
'LockedQty',True).
End.
End

But receive this:
Error Detail
============
Unknown or ambiguous table JobhHead. (725)
** Could not understand line 21. (196)

Michael

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Linda Lowney" <llowney@...> wrote:
>
> Did you try removing the quotes around False ---- ttJobHead.JobClosed
=
> False no-lock:
>
>
>
> Linda
>
>
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
> Of michael.hutcheson@...
> Sent: Thursday, November 26, 2009 9:36 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: Mass lock qty on Jobs
>
>
>
>
>
> Sorry, should be:
>
> For each ttjobhead where ttjobhead.RowMod = 'A' or ttjobhead.RowMod =
> 'U' and ttjobhead.JobClosed = 'False' no-lock:
> If available ttJobhead then do:
> Run lib\UpdateTableBuffer.p(input BUFFER
> ttJobHead:HANDLE,'LockedQty',True).
> End.
>
> Still not working though
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ,
> "michael.hutcheson@" <michael.hutcheson@> wrote:
> >
> > Hello,
> >
> > Tried this:
> >
> > For each ttjobhead where ttjobhead.RowMod = 'A' or ttjobhead.RowMod
=
> 'U' and ttjobhead.LockedQty = 'False' no-lock:
> > If available ttJobhead then do:
> > Run lib\UpdateTableBuffer.p(input BUFFER
> ttJobHead:HANDLE,'LockedQty',True).
> > End.
> >
> > But received:
> >
> > Error Detail
> > ============
> > ** Incompatible data types in expression or assignment. (223)
> > ** Could not understand line 21. (196)
> >
> > Think its going to be a process of elimination!!
> >
> > Michael
> >
> >
> >
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ,
> "Linda Lowney" <llowney@> wrote:
> > >
> > > Hi,
> > >
> > >
> > >
> > > Try removing the quotes around False and True.
> > >
> > >
> > >
> > > Linda
> > >
> > >
> > >
> > > 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 michael.hutcheson@
> > > Sent: Thursday, November 26, 2009 8:17 AM
> > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> > > Subject: [Vantage] Re: Mass lock qty on Jobs
> > >
> > >
> > >
> > >
> > >
> > > Hello,
> > >
> > > I tried:
> > >
> > > find first ttjobhead where ttjobhead.rowmod = 'A' or
> ttjobhead.rowmod =
> > > 'U' no-error.
> > > if ttjobhead.jobclosed = 'False' then do:
> > > assign ttjobhead.lockedqty = 'TRUE'
> > > End
> > >
> > > But got:
> > >
> > > Error Detail
> > > ============
> > > ** Incompatible data types in expression or assignment. (223)
> > > ** Could not understand line 22. (198)
> > >
> > > Also tried:
> > >
> > > find first ttjobhead where ttjobhead.rowmod = 'A' or
> ttjobhead.rowmod =
> > > 'U' and ttjobhead.jobclosed = 'FALSE' no-error.
> > > if available ttjobhead then do:
> > > assign ttjobhead.lockedqty = 'TRUE'
> > > End
> > >
> > > But got:
> > >
> > > Error Detail
> > > ============
> > > ** Incompatible data types in expression or assignment. (223)
> > > ** Could not understand line 21. (196)
> > >
> > > Michael
> > >
> > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com> ,
> > > "bw2868bond" <bwalker@> wrote:
> > > >
> > > > Try
> > > >
> > > > if ttjobhead.JobClosed = 'FALSE' then do:
> > > >
> > > > I think the AVAILABLE keyword is what is blowing it up
> > > >
> > > > --- In vantage@yahoogroups.com
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com> ,
> > > "michael.hutcheson@" <michael.hutcheson@> wrote:
> > > > >
> > > > > I created a preprocessing action on the Job Entry update.
> > > > >
> > > > > action is to execute 4 gl code:
> > > > >
> > > > > find first ttjobhead no-lock no-error.
> > > > >
> > > > > if available ttjobhead.jobclosed = 'FALSE' then do:
> > > > >
> > > > > ttjobhead.LockedQty = 'TRUE'
> > > > >
> > > > > End
> > > > >
> > > > >
> > > > > However, I keep receiving the following error:
> > > > >
> > > > > Error Detail
> > > > > ============
> > > > > Unknown database name ttjobhead. (855)
> > > > > Unknown or ambiguous table jobclosed. (725)
> > > > > ** Could not understand line 23. (198)
> > > > >
> > > > > Any ideas?
> > > > >
> > > > > Michael.
> > > > >
> > > > > --- In vantage@yahoogroups.com
<mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
,
> > > "michael.hutcheson@" <michael.hutcheson@> wrote:
> > > > > >
> > > > > > Hello,
> > > > > >
> > > > > > I need to mass lock the qty on all open jobs.
> > > > > >
> > > > > > I created a BPM on the JobEntry\GetNewJobHead method.
> > > > > >
> > > > > > On the condition (pre processing) I added:
> > > > > >
> > > > > > the Jobhead.JobClosed field of all rows is equal to the
FALSE
> > > value
> > > > > >
> > > > > > Then on the Actions I created:
> > > > > >
> > > > > > set the JobHead.LockedQty field of all rows to the TRUE
value
> > > > > >
> > > > > > I also put the above action in the post processing as well.
> > > > > >
> > > > > > I went into job entry, created a test job and presto the
> Locked
> > > Qty is ticked, however, all the other jobs still have the locked
qty
> > > unticked - how do I do this for all Jobs??
> > > > > >
> > > > > > Thanks for any help
> > > > > >
> > > > > > Michael Hutcheson
> > > > > >
> > > > >
> > > >
> > >
> > >
> > >
> > >
> > >
> > > [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]
Yes so I do!!

Changed it to:

for each JobHead where JobHead.JobClosed = FALSE no-lock:
if available JobHead then do:
Run lib\UpdateTableBuffer.p(input BUFFER JobHead:HANDLE, 'LockedQty',True).
End.
End.

It now validates!!! Just tried to run it and vantage hangs, but it may be processing as I would imagine it will take some time to amend all open jobs...

Michael

--- In vantage@yahoogroups.com, "Linda Lowney" <llowney@...> wrote:
>
> Hi
>
>
>
> Unknown or ambiguous table JobhHead. (725) - it looks like you have an
> extra "h" in JobHead.
>
>
>
> Linda
>
>
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of michael.hutcheson@...
> Sent: Thursday, November 26, 2009 9:57 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Mass lock qty on Jobs
>
>
>
>
>
> Yeah,
>
> I tried this:
>
> for each JobhHead where JobHead.JobClosed = FALSE no-lock:
> if available JobHead then do:
> Run lib\UpdateTableBuffer.p(input BUFFER JobHead:HANDLE,
> 'LockedQty',True).
> End.
> End
>
> But receive this:
> Error Detail
> ============
> Unknown or ambiguous table JobhHead. (725)
> ** Could not understand line 21. (196)
>
> Michael
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "Linda Lowney" <llowney@> wrote:
> >
> > Did you try removing the quotes around False ---- ttJobHead.JobClosed
> =
> > False no-lock:
> >
> >
> >
> > Linda
> >
> >
> >
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> Behalf
> > Of michael.hutcheson@
> > Sent: Thursday, November 26, 2009 9:36 AM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Re: Mass lock qty on Jobs
> >
> >
> >
> >
> >
> > Sorry, should be:
> >
> > For each ttjobhead where ttjobhead.RowMod = 'A' or ttjobhead.RowMod =
> > 'U' and ttjobhead.JobClosed = 'False' no-lock:
> > If available ttJobhead then do:
> > Run lib\UpdateTableBuffer.p(input BUFFER
> > ttJobHead:HANDLE,'LockedQty',True).
> > End.
> >
> > Still not working though
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com> ,
> > "michael.hutcheson@" <michael.hutcheson@> wrote:
> > >
> > > Hello,
> > >
> > > Tried this:
> > >
> > > For each ttjobhead where ttjobhead.RowMod = 'A' or ttjobhead.RowMod
> =
> > 'U' and ttjobhead.LockedQty = 'False' no-lock:
> > > If available ttJobhead then do:
> > > Run lib\UpdateTableBuffer.p(input BUFFER
> > ttJobHead:HANDLE,'LockedQty',True).
> > > End.
> > >
> > > But received:
> > >
> > > Error Detail
> > > ============
> > > ** Incompatible data types in expression or assignment. (223)
> > > ** Could not understand line 21. (196)
> > >
> > > Think its going to be a process of elimination!!
> > >
> > > Michael
> > >
> > >
> > >
> > >
> > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com> ,
> > "Linda Lowney" <llowney@> wrote:
> > > >
> > > > Hi,
> > > >
> > > >
> > > >
> > > > Try removing the quotes around False and True.
> > > >
> > > >
> > > >
> > > > Linda
> > > >
> > > >
> > > >
> > > > 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 michael.hutcheson@
> > > > Sent: Thursday, November 26, 2009 8:17 AM
> > > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> > > > Subject: [Vantage] Re: Mass lock qty on Jobs
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > Hello,
> > > >
> > > > I tried:
> > > >
> > > > find first ttjobhead where ttjobhead.rowmod = 'A' or
> > ttjobhead.rowmod =
> > > > 'U' no-error.
> > > > if ttjobhead.jobclosed = 'False' then do:
> > > > assign ttjobhead.lockedqty = 'TRUE'
> > > > End
> > > >
> > > > But got:
> > > >
> > > > Error Detail
> > > > ============
> > > > ** Incompatible data types in expression or assignment. (223)
> > > > ** Could not understand line 22. (198)
> > > >
> > > > Also tried:
> > > >
> > > > find first ttjobhead where ttjobhead.rowmod = 'A' or
> > ttjobhead.rowmod =
> > > > 'U' and ttjobhead.jobclosed = 'FALSE' no-error.
> > > > if available ttjobhead then do:
> > > > assign ttjobhead.lockedqty = 'TRUE'
> > > > End
> > > >
> > > > But got:
> > > >
> > > > Error Detail
> > > > ============
> > > > ** Incompatible data types in expression or assignment. (223)
> > > > ** Could not understand line 21. (196)
> > > >
> > > > Michael
> > > >
> > > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com> ,
> > > > "bw2868bond" <bwalker@> wrote:
> > > > >
> > > > > Try
> > > > >
> > > > > if ttjobhead.JobClosed = 'FALSE' then do:
> > > > >
> > > > > I think the AVAILABLE keyword is what is blowing it up
> > > > >
> > > > > --- In vantage@yahoogroups.com
> <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com> ,
> > > > "michael.hutcheson@" <michael.hutcheson@> wrote:
> > > > > >
> > > > > > I created a preprocessing action on the Job Entry update.
> > > > > >
> > > > > > action is to execute 4 gl code:
> > > > > >
> > > > > > find first ttjobhead no-lock no-error.
> > > > > >
> > > > > > if available ttjobhead.jobclosed = 'FALSE' then do:
> > > > > >
> > > > > > ttjobhead.LockedQty = 'TRUE'
> > > > > >
> > > > > > End
> > > > > >
> > > > > >
> > > > > > However, I keep receiving the following error:
> > > > > >
> > > > > > Error Detail
> > > > > > ============
> > > > > > Unknown database name ttjobhead. (855)
> > > > > > Unknown or ambiguous table jobclosed. (725)
> > > > > > ** Could not understand line 23. (198)
> > > > > >
> > > > > > Any ideas?
> > > > > >
> > > > > > Michael.
> > > > > >
> > > > > > --- In vantage@yahoogroups.com
> <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
> ,
> > > > "michael.hutcheson@" <michael.hutcheson@> wrote:
> > > > > > >
> > > > > > > Hello,
> > > > > > >
> > > > > > > I need to mass lock the qty on all open jobs.
> > > > > > >
> > > > > > > I created a BPM on the JobEntry\GetNewJobHead method.
> > > > > > >
> > > > > > > On the condition (pre processing) I added:
> > > > > > >
> > > > > > > the Jobhead.JobClosed field of all rows is equal to the
> FALSE
> > > > value
> > > > > > >
> > > > > > > Then on the Actions I created:
> > > > > > >
> > > > > > > set the JobHead.LockedQty field of all rows to the TRUE
> value
> > > > > > >
> > > > > > > I also put the above action in the post processing as well.
> > > > > > >
> > > > > > > I went into job entry, created a test job and presto the
> > Locked
> > > > Qty is ticked, however, all the other jobs still have the locked
> qty
> > > > unticked - how do I do this for all Jobs??
> > > > > > >
> > > > > > > Thanks for any help
> > > > > > >
> > > > > > > Michael Hutcheson
> > > > > > >
> > > > > >
> > > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > [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]
>
Although the below code is validated, it still does not lock the qty's of all open jobs. When you click save, ie. go through the job entry.update methods, its hangs for approx 4 mins, but then does not actually do any thing.

Any ideas?

Michael

--- In vantage@yahoogroups.com, "michael.hutcheson@..." <michael.hutcheson@...> wrote:
>
> Yes so I do!!
>
> Changed it to:
>
> for each JobHead where JobHead.JobClosed = FALSE no-lock:
> if available JobHead then do:
> Run lib\UpdateTableBuffer.p(input BUFFER JobHead:HANDLE, 'LockedQty',True).
> End.
> End.
>
> It now validates!!! Just tried to run it and vantage hangs, but it may be processing as I would imagine it will take some time to amend all open jobs...
>
> Michael
>
> --- In vantage@yahoogroups.com, "Linda Lowney" <llowney@> wrote:
> >
> > Hi
> >
> >
> >
> > Unknown or ambiguous table JobhHead. (725) - it looks like you have an
> > extra "h" in JobHead.
> >
> >
> >
> > Linda
> >
> >
> >
> >
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> > Of michael.hutcheson@
> > Sent: Thursday, November 26, 2009 9:57 AM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Re: Mass lock qty on Jobs
> >
> >
> >
> >
> >
> > Yeah,
> >
> > I tried this:
> >
> > for each JobhHead where JobHead.JobClosed = FALSE no-lock:
> > if available JobHead then do:
> > Run lib\UpdateTableBuffer.p(input BUFFER JobHead:HANDLE,
> > 'LockedQty',True).
> > End.
> > End
> >
> > But receive this:
> > Error Detail
> > ============
> > Unknown or ambiguous table JobhHead. (725)
> > ** Could not understand line 21. (196)
> >
> > Michael
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> > "Linda Lowney" <llowney@> wrote:
> > >
> > > Did you try removing the quotes around False ---- ttJobHead.JobClosed
> > =
> > > False no-lock:
> > >
> > >
> > >
> > > Linda
> > >
> > >
> > >
> > > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> > Behalf
> > > Of michael.hutcheson@
> > > Sent: Thursday, November 26, 2009 9:36 AM
> > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > Subject: [Vantage] Re: Mass lock qty on Jobs
> > >
> > >
> > >
> > >
> > >
> > > Sorry, should be:
> > >
> > > For each ttjobhead where ttjobhead.RowMod = 'A' or ttjobhead.RowMod =
> > > 'U' and ttjobhead.JobClosed = 'False' no-lock:
> > > If available ttJobhead then do:
> > > Run lib\UpdateTableBuffer.p(input BUFFER
> > > ttJobHead:HANDLE,'LockedQty',True).
> > > End.
> > >
> > > Still not working though
> > >
> > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com> ,
> > > "michael.hutcheson@" <michael.hutcheson@> wrote:
> > > >
> > > > Hello,
> > > >
> > > > Tried this:
> > > >
> > > > For each ttjobhead where ttjobhead.RowMod = 'A' or ttjobhead.RowMod
> > =
> > > 'U' and ttjobhead.LockedQty = 'False' no-lock:
> > > > If available ttJobhead then do:
> > > > Run lib\UpdateTableBuffer.p(input BUFFER
> > > ttJobHead:HANDLE,'LockedQty',True).
> > > > End.
> > > >
> > > > But received:
> > > >
> > > > Error Detail
> > > > ============
> > > > ** Incompatible data types in expression or assignment. (223)
> > > > ** Could not understand line 21. (196)
> > > >
> > > > Think its going to be a process of elimination!!
> > > >
> > > > Michael
> > > >
> > > >
> > > >
> > > >
> > > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com> ,
> > > "Linda Lowney" <llowney@> wrote:
> > > > >
> > > > > Hi,
> > > > >
> > > > >
> > > > >
> > > > > Try removing the quotes around False and True.
> > > > >
> > > > >
> > > > >
> > > > > Linda
> > > > >
> > > > >
> > > > >
> > > > > 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 michael.hutcheson@
> > > > > Sent: Thursday, November 26, 2009 8:17 AM
> > > > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com>
> > > > > Subject: [Vantage] Re: Mass lock qty on Jobs
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > Hello,
> > > > >
> > > > > I tried:
> > > > >
> > > > > find first ttjobhead where ttjobhead.rowmod = 'A' or
> > > ttjobhead.rowmod =
> > > > > 'U' no-error.
> > > > > if ttjobhead.jobclosed = 'False' then do:
> > > > > assign ttjobhead.lockedqty = 'TRUE'
> > > > > End
> > > > >
> > > > > But got:
> > > > >
> > > > > Error Detail
> > > > > ============
> > > > > ** Incompatible data types in expression or assignment. (223)
> > > > > ** Could not understand line 22. (198)
> > > > >
> > > > > Also tried:
> > > > >
> > > > > find first ttjobhead where ttjobhead.rowmod = 'A' or
> > > ttjobhead.rowmod =
> > > > > 'U' and ttjobhead.jobclosed = 'FALSE' no-error.
> > > > > if available ttjobhead then do:
> > > > > assign ttjobhead.lockedqty = 'TRUE'
> > > > > End
> > > > >
> > > > > But got:
> > > > >
> > > > > Error Detail
> > > > > ============
> > > > > ** Incompatible data types in expression or assignment. (223)
> > > > > ** Could not understand line 21. (196)
> > > > >
> > > > > Michael
> > > > >
> > > > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com>
> > > <mailto:vantage%40yahoogroups.com> ,
> > > > > "bw2868bond" <bwalker@> wrote:
> > > > > >
> > > > > > Try
> > > > > >
> > > > > > if ttjobhead.JobClosed = 'FALSE' then do:
> > > > > >
> > > > > > I think the AVAILABLE keyword is what is blowing it up
> > > > > >
> > > > > > --- In vantage@yahoogroups.com
> > <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
> > > <mailto:vantage%40yahoogroups.com> ,
> > > > > "michael.hutcheson@" <michael.hutcheson@> wrote:
> > > > > > >
> > > > > > > I created a preprocessing action on the Job Entry update.
> > > > > > >
> > > > > > > action is to execute 4 gl code:
> > > > > > >
> > > > > > > find first ttjobhead no-lock no-error.
> > > > > > >
> > > > > > > if available ttjobhead.jobclosed = 'FALSE' then do:
> > > > > > >
> > > > > > > ttjobhead.LockedQty = 'TRUE'
> > > > > > >
> > > > > > > End
> > > > > > >
> > > > > > >
> > > > > > > However, I keep receiving the following error:
> > > > > > >
> > > > > > > Error Detail
> > > > > > > ============
> > > > > > > Unknown database name ttjobhead. (855)
> > > > > > > Unknown or ambiguous table jobclosed. (725)
> > > > > > > ** Could not understand line 23. (198)
> > > > > > >
> > > > > > > Any ideas?
> > > > > > >
> > > > > > > Michael.
> > > > > > >
> > > > > > > --- In vantage@yahoogroups.com
> > <mailto:vantage%40yahoogroups.com>
> > > <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
> > ,
> > > > > "michael.hutcheson@" <michael.hutcheson@> wrote:
> > > > > > > >
> > > > > > > > Hello,
> > > > > > > >
> > > > > > > > I need to mass lock the qty on all open jobs.
> > > > > > > >
> > > > > > > > I created a BPM on the JobEntry\GetNewJobHead method.
> > > > > > > >
> > > > > > > > On the condition (pre processing) I added:
> > > > > > > >
> > > > > > > > the Jobhead.JobClosed field of all rows is equal to the
> > FALSE
> > > > > value
> > > > > > > >
> > > > > > > > Then on the Actions I created:
> > > > > > > >
> > > > > > > > set the JobHead.LockedQty field of all rows to the TRUE
> > value
> > > > > > > >
> > > > > > > > I also put the above action in the post processing as well.
> > > > > > > >
> > > > > > > > I went into job entry, created a test job and presto the
> > > Locked
> > > > > Qty is ticked, however, all the other jobs still have the locked
> > qty
> > > > > unticked - how do I do this for all Jobs??
> > > > > > > >
> > > > > > > > Thanks for any help
> > > > > > > >
> > > > > > > > Michael Hutcheson
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > [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]
> >
>
Hi Michael,



I'm just learning BPMs and Progress too, but I did something similar for
memos. What is triggering your directive?



We use the ShortChar01 field in Memo entry to enter an initiator's name,
which was a free form field. I wanted them to pick someone from the
Person table so I wrote a BPM to change all the ShortChar01 fields to be
the person code, and since I'm never an initiator on memos I decided to
use my person code as a trigger.



My preprocessing condition was the ttMemo.shortChar01 field has been
changed from any to 'llowney'

My preprocessing action was enable dependent post process directives

My postprocessing condition was this directive has been enabled from the
ck for change in shortchar02 directive

My postprocessing action was similar to yours except I did not have the
no-lock at the end of the for each statement.



for each Memo where Memo.Company = "PS01" and Memo.ShortChar01 = "Barb
Kirkey".

Run lib\UpdateTableBuffer.p(input BUFFER Memo:HANDLE,'ShortChar01',
"BKirkey").

end.



Regards,

Linda

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of michael.hutcheson@...
Sent: Thursday, November 26, 2009 10:41 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Mass lock qty on Jobs





Although the below code is validated, it still does not lock the qty's
of all open jobs. When you click save, ie. go through the job
entry.update methods, its hangs for approx 4 mins, but then does not
actually do any thing.

Any ideas?

Michael

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"michael.hutcheson@..." <michael.hutcheson@...> wrote:
>
> Yes so I do!!
>
> Changed it to:
>
> for each JobHead where JobHead.JobClosed = FALSE no-lock:
> if available JobHead then do:
> Run lib\UpdateTableBuffer.p(input BUFFER JobHead:HANDLE,
'LockedQty',True).
> End.
> End.
>
> It now validates!!! Just tried to run it and vantage hangs, but it may
be processing as I would imagine it will take some time to amend all
open jobs...
>
> Michael
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Linda Lowney" <llowney@> wrote:
> >
> > Hi
> >
> >
> >
> > Unknown or ambiguous table JobhHead. (725) - it looks like you have
an
> > extra "h" in JobHead.
> >
> >
> >
> > Linda
> >
> >
> >
> >
> >
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
> > Of michael.hutcheson@
> > Sent: Thursday, November 26, 2009 9:57 AM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Re: Mass lock qty on Jobs
> >
> >
> >
> >
> >
> > Yeah,
> >
> > I tried this:
> >
> > for each JobhHead where JobHead.JobClosed = FALSE no-lock:
> > if available JobHead then do:
> > Run lib\UpdateTableBuffer.p(input BUFFER JobHead:HANDLE,
> > 'LockedQty',True).
> > End.
> > End
> >
> > But receive this:
> > Error Detail
> > ============
> > Unknown or ambiguous table JobhHead. (725)
> > ** Could not understand line 21. (196)
> >
> > Michael
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ,
> > "Linda Lowney" <llowney@> wrote:
> > >
> > > Did you try removing the quotes around False ----
ttJobHead.JobClosed
> > =
> > > False no-lock:
> > >
> > >
> > >
> > > Linda
> > >
> > >
> > >
> > > 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 michael.hutcheson@
> > > Sent: Thursday, November 26, 2009 9:36 AM
> > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> > > Subject: [Vantage] Re: Mass lock qty on Jobs
> > >
> > >
> > >
> > >
> > >
> > > Sorry, should be:
> > >
> > > For each ttjobhead where ttjobhead.RowMod = 'A' or
ttjobhead.RowMod =
> > > 'U' and ttjobhead.JobClosed = 'False' no-lock:
> > > If available ttJobhead then do:
> > > Run lib\UpdateTableBuffer.p(input BUFFER
> > > ttJobHead:HANDLE,'LockedQty',True).
> > > End.
> > >
> > > Still not working though
> > >
> > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com> ,
> > > "michael.hutcheson@" <michael.hutcheson@> wrote:
> > > >
> > > > Hello,
> > > >
> > > > Tried this:
> > > >
> > > > For each ttjobhead where ttjobhead.RowMod = 'A' or
ttjobhead.RowMod
> > =
> > > 'U' and ttjobhead.LockedQty = 'False' no-lock:
> > > > If available ttJobhead then do:
> > > > Run lib\UpdateTableBuffer.p(input BUFFER
> > > ttJobHead:HANDLE,'LockedQty',True).
> > > > End.
> > > >
> > > > But received:
> > > >
> > > > Error Detail
> > > > ============
> > > > ** Incompatible data types in expression or assignment. (223)
> > > > ** Could not understand line 21. (196)
> > > >
> > > > Think its going to be a process of elimination!!
> > > >
> > > > Michael
> > > >
> > > >
> > > >
> > > >
> > > > --- In vantage@yahoogroups.com
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com> ,
> > > "Linda Lowney" <llowney@> wrote:
> > > > >
> > > > > Hi,
> > > > >
> > > > >
> > > > >
> > > > > Try removing the quotes around False and True.
> > > > >
> > > > >
> > > > >
> > > > > Linda
> > > > >
> > > > >
> > > > >
> > > > > 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 michael.hutcheson@
> > > > > Sent: Thursday, November 26, 2009 8:17 AM
> > > > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com>
> > > > > Subject: [Vantage] Re: Mass lock qty on Jobs
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > Hello,
> > > > >
> > > > > I tried:
> > > > >
> > > > > find first ttjobhead where ttjobhead.rowmod = 'A' or
> > > ttjobhead.rowmod =
> > > > > 'U' no-error.
> > > > > if ttjobhead.jobclosed = 'False' then do:
> > > > > assign ttjobhead.lockedqty = 'TRUE'
> > > > > End
> > > > >
> > > > > But got:
> > > > >
> > > > > Error Detail
> > > > > ============
> > > > > ** Incompatible data types in expression or assignment. (223)
> > > > > ** Could not understand line 22. (198)
> > > > >
> > > > > Also tried:
> > > > >
> > > > > find first ttjobhead where ttjobhead.rowmod = 'A' or
> > > ttjobhead.rowmod =
> > > > > 'U' and ttjobhead.jobclosed = 'FALSE' no-error.
> > > > > if available ttjobhead then do:
> > > > > assign ttjobhead.lockedqty = 'TRUE'
> > > > > End
> > > > >
> > > > > But got:
> > > > >
> > > > > Error Detail
> > > > > ============
> > > > > ** Incompatible data types in expression or assignment. (223)
> > > > > ** Could not understand line 21. (196)
> > > > >
> > > > > Michael
> > > > >
> > > > > --- In vantage@yahoogroups.com
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com>
> > > <mailto:vantage%40yahoogroups.com> ,
> > > > > "bw2868bond" <bwalker@> wrote:
> > > > > >
> > > > > > Try
> > > > > >
> > > > > > if ttjobhead.JobClosed = 'FALSE' then do:
> > > > > >
> > > > > > I think the AVAILABLE keyword is what is blowing it up
> > > > > >
> > > > > > --- In vantage@yahoogroups.com
<mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> > > <mailto:vantage%40yahoogroups.com> ,
> > > > > "michael.hutcheson@" <michael.hutcheson@> wrote:
> > > > > > >
> > > > > > > I created a preprocessing action on the Job Entry update.
> > > > > > >
> > > > > > > action is to execute 4 gl code:
> > > > > > >
> > > > > > > find first ttjobhead no-lock no-error.
> > > > > > >
> > > > > > > if available ttjobhead.jobclosed = 'FALSE' then do:
> > > > > > >
> > > > > > > ttjobhead.LockedQty = 'TRUE'
> > > > > > >
> > > > > > > End
> > > > > > >
> > > > > > >
> > > > > > > However, I keep receiving the following error:
> > > > > > >
> > > > > > > Error Detail
> > > > > > > ============
> > > > > > > Unknown database name ttjobhead. (855)
> > > > > > > Unknown or ambiguous table jobclosed. (725)
> > > > > > > ** Could not understand line 23. (198)
> > > > > > >
> > > > > > > Any ideas?
> > > > > > >
> > > > > > > Michael.
> > > > > > >
> > > > > > > --- In vantage@yahoogroups.com
<mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com>
> > > <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> > ,
> > > > > "michael.hutcheson@" <michael.hutcheson@> wrote:
> > > > > > > >
> > > > > > > > Hello,
> > > > > > > >
> > > > > > > > I need to mass lock the qty on all open jobs.
> > > > > > > >
> > > > > > > > I created a BPM on the JobEntry\GetNewJobHead method.
> > > > > > > >
> > > > > > > > On the condition (pre processing) I added:
> > > > > > > >
> > > > > > > > the Jobhead.JobClosed field of all rows is equal to the
> > FALSE
> > > > > value
> > > > > > > >
> > > > > > > > Then on the Actions I created:
> > > > > > > >
> > > > > > > > set the JobHead.LockedQty field of all rows to the TRUE
> > value
> > > > > > > >
> > > > > > > > I also put the above action in the post processing as
well.
> > > > > > > >
> > > > > > > > I went into job entry, created a test job and presto the
> > > Locked
> > > > > Qty is ticked, however, all the other jobs still have the
locked
> > qty
> > > > > unticked - how do I do this for all Jobs??
> > > > > > > >
> > > > > > > > Thanks for any help
> > > > > > > >
> > > > > > > > Michael Hutcheson
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > [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]
Hello Linda,

The directive is triggered by the job entry.update - so I was just making one change then clicking save to trigger the action.

So did you get it to update all memo\shortchar01 to "BKirkey" across the whole database? The only thing missing from mine now would seem the company. I had no conditions, only actions. I've tried it on pre\processing as well.

PS. I'm in the UK so will be going home in about 20 mins.

Michael

--- In vantage@yahoogroups.com, "Linda Lowney" <llowney@...> wrote:
>
> Hi Michael,
>
>
>
> I'm just learning BPMs and Progress too, but I did something similar for
> memos. What is triggering your directive?
>
>
>
> We use the ShortChar01 field in Memo entry to enter an initiator's name,
> which was a free form field. I wanted them to pick someone from the
> Person table so I wrote a BPM to change all the ShortChar01 fields to be
> the person code, and since I'm never an initiator on memos I decided to
> use my person code as a trigger.
>
>
>
> My preprocessing condition was the ttMemo.shortChar01 field has been
> changed from any to 'llowney'
>
> My preprocessing action was enable dependent post process directives
>
> My postprocessing condition was this directive has been enabled from the
> ck for change in shortchar02 directive
>
> My postprocessing action was similar to yours except I did not have the
> no-lock at the end of the for each statement.
>
>
>
> for each Memo where Memo.Company = "PS01" and Memo.ShortChar01 = "Barb
> Kirkey".
>
> Run lib\UpdateTableBuffer.p(input BUFFER Memo:HANDLE,'ShortChar01',
> "BKirkey").
>
> end.
>
>
>
> Regards,
>
> Linda
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of michael.hutcheson@...
> Sent: Thursday, November 26, 2009 10:41 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Mass lock qty on Jobs
>
>
>
>
>
> Although the below code is validated, it still does not lock the qty's
> of all open jobs. When you click save, ie. go through the job
> entry.update methods, its hangs for approx 4 mins, but then does not
> actually do any thing.
>
> Any ideas?
>
> Michael
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "michael.hutcheson@" <michael.hutcheson@> wrote:
> >
> > Yes so I do!!
> >
> > Changed it to:
> >
> > for each JobHead where JobHead.JobClosed = FALSE no-lock:
> > if available JobHead then do:
> > Run lib\UpdateTableBuffer.p(input BUFFER JobHead:HANDLE,
> 'LockedQty',True).
> > End.
> > End.
> >
> > It now validates!!! Just tried to run it and vantage hangs, but it may
> be processing as I would imagine it will take some time to amend all
> open jobs...
> >
> > Michael
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "Linda Lowney" <llowney@> wrote:
> > >
> > > Hi
> > >
> > >
> > >
> > > Unknown or ambiguous table JobhHead. (725) - it looks like you have
> an
> > > extra "h" in JobHead.
> > >
> > >
> > >
> > > Linda
> > >
> > >
> > >
> > >
> > >
> > > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> Behalf
> > > Of michael.hutcheson@
> > > Sent: Thursday, November 26, 2009 9:57 AM
> > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > Subject: [Vantage] Re: Mass lock qty on Jobs
> > >
> > >
> > >
> > >
> > >
> > > Yeah,
> > >
> > > I tried this:
> > >
> > > for each JobhHead where JobHead.JobClosed = FALSE no-lock:
> > > if available JobHead then do:
> > > Run lib\UpdateTableBuffer.p(input BUFFER JobHead:HANDLE,
> > > 'LockedQty',True).
> > > End.
> > > End
> > >
> > > But receive this:
> > > Error Detail
> > > ============
> > > Unknown or ambiguous table JobhHead. (725)
> > > ** Could not understand line 21. (196)
> > >
> > > Michael
> > >
> > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com> ,
> > > "Linda Lowney" <llowney@> wrote:
> > > >
> > > > Did you try removing the quotes around False ----
> ttJobHead.JobClosed
> > > =
> > > > False no-lock:
> > > >
> > > >
> > > >
> > > > Linda
> > > >
> > > >
> > > >
> > > > 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 michael.hutcheson@
> > > > Sent: Thursday, November 26, 2009 9:36 AM
> > > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> > > > Subject: [Vantage] Re: Mass lock qty on Jobs
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > Sorry, should be:
> > > >
> > > > For each ttjobhead where ttjobhead.RowMod = 'A' or
> ttjobhead.RowMod =
> > > > 'U' and ttjobhead.JobClosed = 'False' no-lock:
> > > > If available ttJobhead then do:
> > > > Run lib\UpdateTableBuffer.p(input BUFFER
> > > > ttJobHead:HANDLE,'LockedQty',True).
> > > > End.
> > > >
> > > > Still not working though
> > > >
> > > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> > > <mailto:vantage%40yahoogroups.com> ,
> > > > "michael.hutcheson@" <michael.hutcheson@> wrote:
> > > > >
> > > > > Hello,
> > > > >
> > > > > Tried this:
> > > > >
> > > > > For each ttjobhead where ttjobhead.RowMod = 'A' or
> ttjobhead.RowMod
> > > =
> > > > 'U' and ttjobhead.LockedQty = 'False' no-lock:
> > > > > If available ttJobhead then do:
> > > > > Run lib\UpdateTableBuffer.p(input BUFFER
> > > > ttJobHead:HANDLE,'LockedQty',True).
> > > > > End.
> > > > >
> > > > > But received:
> > > > >
> > > > > Error Detail
> > > > > ============
> > > > > ** Incompatible data types in expression or assignment. (223)
> > > > > ** Could not understand line 21. (196)
> > > > >
> > > > > Think its going to be a process of elimination!!
> > > > >
> > > > > Michael
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > --- In vantage@yahoogroups.com
> <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
> > > <mailto:vantage%40yahoogroups.com> ,
> > > > "Linda Lowney" <llowney@> wrote:
> > > > > >
> > > > > > Hi,
> > > > > >
> > > > > >
> > > > > >
> > > > > > Try removing the quotes around False and True.
> > > > > >
> > > > > >
> > > > > >
> > > > > > Linda
> > > > > >
> > > > > >
> > > > > >
> > > > > > 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 michael.hutcheson@
> > > > > > Sent: Thursday, November 26, 2009 8:17 AM
> > > > > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> > > <mailto:vantage%40yahoogroups.com>
> > > > > > Subject: [Vantage] Re: Mass lock qty on Jobs
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > > Hello,
> > > > > >
> > > > > > I tried:
> > > > > >
> > > > > > find first ttjobhead where ttjobhead.rowmod = 'A' or
> > > > ttjobhead.rowmod =
> > > > > > 'U' no-error.
> > > > > > if ttjobhead.jobclosed = 'False' then do:
> > > > > > assign ttjobhead.lockedqty = 'TRUE'
> > > > > > End
> > > > > >
> > > > > > But got:
> > > > > >
> > > > > > Error Detail
> > > > > > ============
> > > > > > ** Incompatible data types in expression or assignment. (223)
> > > > > > ** Could not understand line 22. (198)
> > > > > >
> > > > > > Also tried:
> > > > > >
> > > > > > find first ttjobhead where ttjobhead.rowmod = 'A' or
> > > > ttjobhead.rowmod =
> > > > > > 'U' and ttjobhead.jobclosed = 'FALSE' no-error.
> > > > > > if available ttjobhead then do:
> > > > > > assign ttjobhead.lockedqty = 'TRUE'
> > > > > > End
> > > > > >
> > > > > > But got:
> > > > > >
> > > > > > Error Detail
> > > > > > ============
> > > > > > ** Incompatible data types in expression or assignment. (223)
> > > > > > ** Could not understand line 21. (196)
> > > > > >
> > > > > > Michael
> > > > > >
> > > > > > --- In vantage@yahoogroups.com
> <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
> > > <mailto:vantage%40yahoogroups.com>
> > > > <mailto:vantage%40yahoogroups.com> ,
> > > > > > "bw2868bond" <bwalker@> wrote:
> > > > > > >
> > > > > > > Try
> > > > > > >
> > > > > > > if ttjobhead.JobClosed = 'FALSE' then do:
> > > > > > >
> > > > > > > I think the AVAILABLE keyword is what is blowing it up
> > > > > > >
> > > > > > > --- In vantage@yahoogroups.com
> <mailto:vantage%40yahoogroups.com>
> > > <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> > > > <mailto:vantage%40yahoogroups.com> ,
> > > > > > "michael.hutcheson@" <michael.hutcheson@> wrote:
> > > > > > > >
> > > > > > > > I created a preprocessing action on the Job Entry update.
> > > > > > > >
> > > > > > > > action is to execute 4 gl code:
> > > > > > > >
> > > > > > > > find first ttjobhead no-lock no-error.
> > > > > > > >
> > > > > > > > if available ttjobhead.jobclosed = 'FALSE' then do:
> > > > > > > >
> > > > > > > > ttjobhead.LockedQty = 'TRUE'
> > > > > > > >
> > > > > > > > End
> > > > > > > >
> > > > > > > >
> > > > > > > > However, I keep receiving the following error:
> > > > > > > >
> > > > > > > > Error Detail
> > > > > > > > ============
> > > > > > > > Unknown database name ttjobhead. (855)
> > > > > > > > Unknown or ambiguous table jobclosed. (725)
> > > > > > > > ** Could not understand line 23. (198)
> > > > > > > >
> > > > > > > > Any ideas?
> > > > > > > >
> > > > > > > > Michael.
> > > > > > > >
> > > > > > > > --- In vantage@yahoogroups.com
> <mailto:vantage%40yahoogroups.com>
> > > <mailto:vantage%40yahoogroups.com>
> > > > <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> > > ,
> > > > > > "michael.hutcheson@" <michael.hutcheson@> wrote:
> > > > > > > > >
> > > > > > > > > Hello,
> > > > > > > > >
> > > > > > > > > I need to mass lock the qty on all open jobs.
> > > > > > > > >
> > > > > > > > > I created a BPM on the JobEntry\GetNewJobHead method.
> > > > > > > > >
> > > > > > > > > On the condition (pre processing) I added:
> > > > > > > > >
> > > > > > > > > the Jobhead.JobClosed field of all rows is equal to the
> > > FALSE
> > > > > > value
> > > > > > > > >
> > > > > > > > > Then on the Actions I created:
> > > > > > > > >
> > > > > > > > > set the JobHead.LockedQty field of all rows to the TRUE
> > > value
> > > > > > > > >
> > > > > > > > > I also put the above action in the post processing as
> well.
> > > > > > > > >
> > > > > > > > > I went into job entry, created a test job and presto the
> > > > Locked
> > > > > > Qty is ticked, however, all the other jobs still have the
> locked
> > > qty
> > > > > > unticked - how do I do this for all Jobs??
> > > > > > > > >
> > > > > > > > > Thanks for any help
> > > > > > > > >
> > > > > > > > > Michael Hutcheson
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > > [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]
>
Hi Michael,



I actually had a lot of different names, initials etc to change so the
program was very long and yes it worked ok for me.



Regards,

Linda



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of michael.hutcheson@...
Sent: Thursday, November 26, 2009 11:14 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Mass lock qty on Jobs





Hello Linda,

The directive is triggered by the job entry.update - so I was just
making one change then clicking save to trigger the action.

So did you get it to update all memo\shortchar01 to "BKirkey" across the
whole database? The only thing missing from mine now would seem the
company. I had no conditions, only actions. I've tried it on
pre\processing as well.

PS. I'm in the UK so will be going home in about 20 mins.

Michael

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Linda Lowney" <llowney@...> wrote:
>
> Hi Michael,
>
>
>
> I'm just learning BPMs and Progress too, but I did something similar
for
> memos. What is triggering your directive?
>
>
>
> We use the ShortChar01 field in Memo entry to enter an initiator's
name,
> which was a free form field. I wanted them to pick someone from the
> Person table so I wrote a BPM to change all the ShortChar01 fields to
be
> the person code, and since I'm never an initiator on memos I decided
to
> use my person code as a trigger.
>
>
>
> My preprocessing condition was the ttMemo.shortChar01 field has been
> changed from any to 'llowney'
>
> My preprocessing action was enable dependent post process directives
>
> My postprocessing condition was this directive has been enabled from
the
> ck for change in shortchar02 directive
>
> My postprocessing action was similar to yours except I did not have
the
> no-lock at the end of the for each statement.
>
>
>
> for each Memo where Memo.Company = "PS01" and Memo.ShortChar01 = "Barb
> Kirkey".
>
> Run lib\UpdateTableBuffer.p(input BUFFER Memo:HANDLE,'ShortChar01',
> "BKirkey").
>
> end.
>
>
>
> Regards,
>
> Linda
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
> Of michael.hutcheson@...
> Sent: Thursday, November 26, 2009 10:41 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: Mass lock qty on Jobs
>
>
>
>
>
> Although the below code is validated, it still does not lock the qty's
> of all open jobs. When you click save, ie. go through the job
> entry.update methods, its hangs for approx 4 mins, but then does not
> actually do any thing.
>
> Any ideas?
>
> Michael
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ,
> "michael.hutcheson@" <michael.hutcheson@> wrote:
> >
> > Yes so I do!!
> >
> > Changed it to:
> >
> > for each JobHead where JobHead.JobClosed = FALSE no-lock:
> > if available JobHead then do:
> > Run lib\UpdateTableBuffer.p(input BUFFER JobHead:HANDLE,
> 'LockedQty',True).
> > End.
> > End.
> >
> > It now validates!!! Just tried to run it and vantage hangs, but it
may
> be processing as I would imagine it will take some time to amend all
> open jobs...
> >
> > Michael
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ,
> "Linda Lowney" <llowney@> wrote:
> > >
> > > Hi
> > >
> > >
> > >
> > > Unknown or ambiguous table JobhHead. (725) - it looks like you
have
> an
> > > extra "h" in JobHead.
> > >
> > >
> > >
> > > Linda
> > >
> > >
> > >
> > >
> > >
> > > 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 michael.hutcheson@
> > > Sent: Thursday, November 26, 2009 9:57 AM
> > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> > > Subject: [Vantage] Re: Mass lock qty on Jobs
> > >
> > >
> > >
> > >
> > >
> > > Yeah,
> > >
> > > I tried this:
> > >
> > > for each JobhHead where JobHead.JobClosed = FALSE no-lock:
> > > if available JobHead then do:
> > > Run lib\UpdateTableBuffer.p(input BUFFER JobHead:HANDLE,
> > > 'LockedQty',True).
> > > End.
> > > End
> > >
> > > But receive this:
> > > Error Detail
> > > ============
> > > Unknown or ambiguous table JobhHead. (725)
> > > ** Could not understand line 21. (196)
> > >
> > > Michael
> > >
> > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com> ,
> > > "Linda Lowney" <llowney@> wrote:
> > > >
> > > > Did you try removing the quotes around False ----
> ttJobHead.JobClosed
> > > =
> > > > False no-lock:
> > > >
> > > >
> > > >
> > > > Linda
> > > >
> > > >
> > > >
> > > > 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 michael.hutcheson@
> > > > Sent: Thursday, November 26, 2009 9:36 AM
> > > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> > > > Subject: [Vantage] Re: Mass lock qty on Jobs
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > Sorry, should be:
> > > >
> > > > For each ttjobhead where ttjobhead.RowMod = 'A' or
> ttjobhead.RowMod =
> > > > 'U' and ttjobhead.JobClosed = 'False' no-lock:
> > > > If available ttJobhead then do:
> > > > Run lib\UpdateTableBuffer.p(input BUFFER
> > > > ttJobHead:HANDLE,'LockedQty',True).
> > > > End.
> > > >
> > > > Still not working though
> > > >
> > > > --- In vantage@yahoogroups.com
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> > > <mailto:vantage%40yahoogroups.com> ,
> > > > "michael.hutcheson@" <michael.hutcheson@> wrote:
> > > > >
> > > > > Hello,
> > > > >
> > > > > Tried this:
> > > > >
> > > > > For each ttjobhead where ttjobhead.RowMod = 'A' or
> ttjobhead.RowMod
> > > =
> > > > 'U' and ttjobhead.LockedQty = 'False' no-lock:
> > > > > If available ttJobhead then do:
> > > > > Run lib\UpdateTableBuffer.p(input BUFFER
> > > > ttJobHead:HANDLE,'LockedQty',True).
> > > > > End.
> > > > >
> > > > > But received:
> > > > >
> > > > > Error Detail
> > > > > ============
> > > > > ** Incompatible data types in expression or assignment. (223)
> > > > > ** Could not understand line 21. (196)
> > > > >
> > > > > Think its going to be a process of elimination!!
> > > > >
> > > > > Michael
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > --- In vantage@yahoogroups.com
<mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
> > > <mailto:vantage%40yahoogroups.com> ,
> > > > "Linda Lowney" <llowney@> wrote:
> > > > > >
> > > > > > Hi,
> > > > > >
> > > > > >
> > > > > >
> > > > > > Try removing the quotes around False and True.
> > > > > >
> > > > > >
> > > > > >
> > > > > > Linda
> > > > > >
> > > > > >
> > > > > >
> > > > > > 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 michael.hutcheson@
> > > > > > Sent: Thursday, November 26, 2009 8:17 AM
> > > > > > To: vantage@yahoogroups.com
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> > > <mailto:vantage%40yahoogroups.com>
> > > > > > Subject: [Vantage] Re: Mass lock qty on Jobs
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > > Hello,
> > > > > >
> > > > > > I tried:
> > > > > >
> > > > > > find first ttjobhead where ttjobhead.rowmod = 'A' or
> > > > ttjobhead.rowmod =
> > > > > > 'U' no-error.
> > > > > > if ttjobhead.jobclosed = 'False' then do:
> > > > > > assign ttjobhead.lockedqty = 'TRUE'
> > > > > > End
> > > > > >
> > > > > > But got:
> > > > > >
> > > > > > Error Detail
> > > > > > ============
> > > > > > ** Incompatible data types in expression or assignment.
(223)
> > > > > > ** Could not understand line 22. (198)
> > > > > >
> > > > > > Also tried:
> > > > > >
> > > > > > find first ttjobhead where ttjobhead.rowmod = 'A' or
> > > > ttjobhead.rowmod =
> > > > > > 'U' and ttjobhead.jobclosed = 'FALSE' no-error.
> > > > > > if available ttjobhead then do:
> > > > > > assign ttjobhead.lockedqty = 'TRUE'
> > > > > > End
> > > > > >
> > > > > > But got:
> > > > > >
> > > > > > Error Detail
> > > > > > ============
> > > > > > ** Incompatible data types in expression or assignment.
(223)
> > > > > > ** Could not understand line 21. (196)
> > > > > >
> > > > > > Michael
> > > > > >
> > > > > > --- In vantage@yahoogroups.com
<mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
> > > <mailto:vantage%40yahoogroups.com>
> > > > <mailto:vantage%40yahoogroups.com> ,
> > > > > > "bw2868bond" <bwalker@> wrote:
> > > > > > >
> > > > > > > Try
> > > > > > >
> > > > > > > if ttjobhead.JobClosed = 'FALSE' then do:
> > > > > > >
> > > > > > > I think the AVAILABLE keyword is what is blowing it up
> > > > > > >
> > > > > > > --- In vantage@yahoogroups.com
<mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> > > <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> > > > <mailto:vantage%40yahoogroups.com> ,
> > > > > > "michael.hutcheson@" <michael.hutcheson@> wrote:
> > > > > > > >
> > > > > > > > I created a preprocessing action on the Job Entry
update.
> > > > > > > >
> > > > > > > > action is to execute 4 gl code:
> > > > > > > >
> > > > > > > > find first ttjobhead no-lock no-error.
> > > > > > > >
> > > > > > > > if available ttjobhead.jobclosed = 'FALSE' then do:
> > > > > > > >
> > > > > > > > ttjobhead.LockedQty = 'TRUE'
> > > > > > > >
> > > > > > > > End
> > > > > > > >
> > > > > > > >
> > > > > > > > However, I keep receiving the following error:
> > > > > > > >
> > > > > > > > Error Detail
> > > > > > > > ============
> > > > > > > > Unknown database name ttjobhead. (855)
> > > > > > > > Unknown or ambiguous table jobclosed. (725)
> > > > > > > > ** Could not understand line 23. (198)
> > > > > > > >
> > > > > > > > Any ideas?
> > > > > > > >
> > > > > > > > Michael.
> > > > > > > >
> > > > > > > > --- In vantage@yahoogroups.com
<mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> > > <mailto:vantage%40yahoogroups.com>
> > > > <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> > > ,
> > > > > > "michael.hutcheson@" <michael.hutcheson@> wrote:
> > > > > > > > >
> > > > > > > > > Hello,
> > > > > > > > >
> > > > > > > > > I need to mass lock the qty on all open jobs.
> > > > > > > > >
> > > > > > > > > I created a BPM on the JobEntry\GetNewJobHead method.
> > > > > > > > >
> > > > > > > > > On the condition (pre processing) I added:
> > > > > > > > >
> > > > > > > > > the Jobhead.JobClosed field of all rows is equal to
the
> > > FALSE
> > > > > > value
> > > > > > > > >
> > > > > > > > > Then on the Actions I created:
> > > > > > > > >
> > > > > > > > > set the JobHead.LockedQty field of all rows to the
TRUE
> > > value
> > > > > > > > >
> > > > > > > > > I also put the above action in the post processing as
> well.
> > > > > > > > >
> > > > > > > > > I went into job entry, created a test job and presto
the
> > > > Locked
> > > > > > Qty is ticked, however, all the other jobs still have the
> locked
> > > qty
> > > > > > unticked - how do I do this for all Jobs??
> > > > > > > > >
> > > > > > > > > Thanks for any help
> > > > > > > > >
> > > > > > > > > Michael Hutcheson
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > > [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]
You don't need the "If AVAILABLE" condition with the "For Each" loop.

Try:

for each JobHead where JobHead.JobClosed = FALSE no-lock:
Run lib\UpdateTableBuffer.p(input BUFFER JobHead:HANDLE, 'LockedQty',True).
End.

Dele Oyebande

--- In vantage@yahoogroups.com, "michael.hutcheson@..." <michael.hutcheson@...> wrote:
>
> Although the below code is validated, it still does not lock the qty's of all open jobs. When you click save, ie. go through the job entry.update methods, its hangs for approx 4 mins, but then does not actually do any thing.
>
> Any ideas?
>
> Michael
>
> --- In vantage@yahoogroups.com, "michael.hutcheson@" <michael.hutcheson@> wrote:
> >
> > Yes so I do!!
> >
> > Changed it to:
> >
> > for each JobHead where JobHead.JobClosed = FALSE no-lock:
> > if available JobHead then do:
> > Run lib\UpdateTableBuffer.p(input BUFFER JobHead:HANDLE, 'LockedQty',True).
> > End.
> > End.
> >
> > It now validates!!! Just tried to run it and vantage hangs, but it may be processing as I would imagine it will take some time to amend all open jobs...
> >
> > Michael
> >
> > --- In vantage@yahoogroups.com, "Linda Lowney" <llowney@> wrote:
> > >
> > > Hi
> > >
> > >
> > >
> > > Unknown or ambiguous table JobhHead. (725) - it looks like you have an
> > > extra "h" in JobHead.
> > >
> > >
> > >
> > > Linda
> > >
> > >
> > >
> > >
> > >
> > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> > > Of michael.hutcheson@
> > > Sent: Thursday, November 26, 2009 9:57 AM
> > > To: vantage@yahoogroups.com
> > > Subject: [Vantage] Re: Mass lock qty on Jobs
> > >
> > >
> > >
> > >
> > >
> > > Yeah,
> > >
> > > I tried this:
> > >
> > > for each JobhHead where JobHead.JobClosed = FALSE no-lock:
> > > if available JobHead then do:
> > > Run lib\UpdateTableBuffer.p(input BUFFER JobHead:HANDLE,
> > > 'LockedQty',True).
> > > End.
> > > End
> > >
> > > But receive this:
> > > Error Detail
> > > ============
> > > Unknown or ambiguous table JobhHead. (725)
> > > ** Could not understand line 21. (196)
> > >
> > > Michael
> > >
> > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> > > "Linda Lowney" <llowney@> wrote:
> > > >
> > > > Did you try removing the quotes around False ---- ttJobHead.JobClosed
> > > =
> > > > False no-lock:
> > > >
> > > >
> > > >
> > > > Linda
> > > >
> > > >
> > > >
> > > > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> > > Behalf
> > > > Of michael.hutcheson@
> > > > Sent: Thursday, November 26, 2009 9:36 AM
> > > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > > Subject: [Vantage] Re: Mass lock qty on Jobs
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > Sorry, should be:
> > > >
> > > > For each ttjobhead where ttjobhead.RowMod = 'A' or ttjobhead.RowMod =
> > > > 'U' and ttjobhead.JobClosed = 'False' no-lock:
> > > > If available ttJobhead then do:
> > > > Run lib\UpdateTableBuffer.p(input BUFFER
> > > > ttJobHead:HANDLE,'LockedQty',True).
> > > > End.
> > > >
> > > > Still not working though
> > > >
> > > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > <mailto:vantage%40yahoogroups.com> ,
> > > > "michael.hutcheson@" <michael.hutcheson@> wrote:
> > > > >
> > > > > Hello,
> > > > >
> > > > > Tried this:
> > > > >
> > > > > For each ttjobhead where ttjobhead.RowMod = 'A' or ttjobhead.RowMod
> > > =
> > > > 'U' and ttjobhead.LockedQty = 'False' no-lock:
> > > > > If available ttJobhead then do:
> > > > > Run lib\UpdateTableBuffer.p(input BUFFER
> > > > ttJobHead:HANDLE,'LockedQty',True).
> > > > > End.
> > > > >
> > > > > But received:
> > > > >
> > > > > Error Detail
> > > > > ============
> > > > > ** Incompatible data types in expression or assignment. (223)
> > > > > ** Could not understand line 21. (196)
> > > > >
> > > > > Think its going to be a process of elimination!!
> > > > >
> > > > > Michael
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > <mailto:vantage%40yahoogroups.com> ,
> > > > "Linda Lowney" <llowney@> wrote:
> > > > > >
> > > > > > Hi,
> > > > > >
> > > > > >
> > > > > >
> > > > > > Try removing the quotes around False and True.
> > > > > >
> > > > > >
> > > > > >
> > > > > > Linda
> > > > > >
> > > > > >
> > > > > >
> > > > > > 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 michael.hutcheson@
> > > > > > Sent: Thursday, November 26, 2009 8:17 AM
> > > > > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > <mailto:vantage%40yahoogroups.com>
> > > > > > Subject: [Vantage] Re: Mass lock qty on Jobs
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > > Hello,
> > > > > >
> > > > > > I tried:
> > > > > >
> > > > > > find first ttjobhead where ttjobhead.rowmod = 'A' or
> > > > ttjobhead.rowmod =
> > > > > > 'U' no-error.
> > > > > > if ttjobhead.jobclosed = 'False' then do:
> > > > > > assign ttjobhead.lockedqty = 'TRUE'
> > > > > > End
> > > > > >
> > > > > > But got:
> > > > > >
> > > > > > Error Detail
> > > > > > ============
> > > > > > ** Incompatible data types in expression or assignment. (223)
> > > > > > ** Could not understand line 22. (198)
> > > > > >
> > > > > > Also tried:
> > > > > >
> > > > > > find first ttjobhead where ttjobhead.rowmod = 'A' or
> > > > ttjobhead.rowmod =
> > > > > > 'U' and ttjobhead.jobclosed = 'FALSE' no-error.
> > > > > > if available ttjobhead then do:
> > > > > > assign ttjobhead.lockedqty = 'TRUE'
> > > > > > End
> > > > > >
> > > > > > But got:
> > > > > >
> > > > > > Error Detail
> > > > > > ============
> > > > > > ** Incompatible data types in expression or assignment. (223)
> > > > > > ** Could not understand line 21. (196)
> > > > > >
> > > > > > Michael
> > > > > >
> > > > > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > <mailto:vantage%40yahoogroups.com>
> > > > <mailto:vantage%40yahoogroups.com> ,
> > > > > > "bw2868bond" <bwalker@> wrote:
> > > > > > >
> > > > > > > Try
> > > > > > >
> > > > > > > if ttjobhead.JobClosed = 'FALSE' then do:
> > > > > > >
> > > > > > > I think the AVAILABLE keyword is what is blowing it up
> > > > > > >
> > > > > > > --- In vantage@yahoogroups.com
> > > <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
> > > > <mailto:vantage%40yahoogroups.com> ,
> > > > > > "michael.hutcheson@" <michael.hutcheson@> wrote:
> > > > > > > >
> > > > > > > > I created a preprocessing action on the Job Entry update.
> > > > > > > >
> > > > > > > > action is to execute 4 gl code:
> > > > > > > >
> > > > > > > > find first ttjobhead no-lock no-error.
> > > > > > > >
> > > > > > > > if available ttjobhead.jobclosed = 'FALSE' then do:
> > > > > > > >
> > > > > > > > ttjobhead.LockedQty = 'TRUE'
> > > > > > > >
> > > > > > > > End
> > > > > > > >
> > > > > > > >
> > > > > > > > However, I keep receiving the following error:
> > > > > > > >
> > > > > > > > Error Detail
> > > > > > > > ============
> > > > > > > > Unknown database name ttjobhead. (855)
> > > > > > > > Unknown or ambiguous table jobclosed. (725)
> > > > > > > > ** Could not understand line 23. (198)
> > > > > > > >
> > > > > > > > Any ideas?
> > > > > > > >
> > > > > > > > Michael.
> > > > > > > >
> > > > > > > > --- In vantage@yahoogroups.com
> > > <mailto:vantage%40yahoogroups.com>
> > > > <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
> > > ,
> > > > > > "michael.hutcheson@" <michael.hutcheson@> wrote:
> > > > > > > > >
> > > > > > > > > Hello,
> > > > > > > > >
> > > > > > > > > I need to mass lock the qty on all open jobs.
> > > > > > > > >
> > > > > > > > > I created a BPM on the JobEntry\GetNewJobHead method.
> > > > > > > > >
> > > > > > > > > On the condition (pre processing) I added:
> > > > > > > > >
> > > > > > > > > the Jobhead.JobClosed field of all rows is equal to the
> > > FALSE
> > > > > > value
> > > > > > > > >
> > > > > > > > > Then on the Actions I created:
> > > > > > > > >
> > > > > > > > > set the JobHead.LockedQty field of all rows to the TRUE
> > > value
> > > > > > > > >
> > > > > > > > > I also put the above action in the post processing as well.
> > > > > > > > >
> > > > > > > > > I went into job entry, created a test job and presto the
> > > > Locked
> > > > > > Qty is ticked, however, all the other jobs still have the locked
> > > qty
> > > > > > unticked - how do I do this for all Jobs??
> > > > > > > > >
> > > > > > > > > Thanks for any help
> > > > > > > > >
> > > > > > > > > Michael Hutcheson
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > > [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]
> > >
> >
>
Hello,

Thanks for this.

Tried the code but received the following when validating:

The following application error was encountered:

** Unknown table name er. (200)
** Could not understand line 22. (196)

Michael




--- In vantage@yahoogroups.com, "deleoye" <deleoye@...> wrote:
>
>
>
> You don't need the "If AVAILABLE" condition with the "For Each" loop.
>
> Try:
>
> for each JobHead where JobHead.JobClosed = FALSE no-lock:
> Run lib\UpdateTableBuffer.p(input BUFFER JobHead:HANDLE, 'LockedQty',True).
> End.
>
> Dele Oyebande
>
> --- In vantage@yahoogroups.com, "michael.hutcheson@" <michael.hutcheson@> wrote:
> >
> > Although the below code is validated, it still does not lock the qty's of all open jobs. When you click save, ie. go through the job entry.update methods, its hangs for approx 4 mins, but then does not actually do any thing.
> >
> > Any ideas?
> >
> > Michael
> >
> > --- In vantage@yahoogroups.com, "michael.hutcheson@" <michael.hutcheson@> wrote:
> > >
> > > Yes so I do!!
> > >
> > > Changed it to:
> > >
> > > for each JobHead where JobHead.JobClosed = FALSE no-lock:
> > > if available JobHead then do:
> > > Run lib\UpdateTableBuffer.p(input BUFFER JobHead:HANDLE, 'LockedQty',True).
> > > End.
> > > End.
> > >
> > > It now validates!!! Just tried to run it and vantage hangs, but it may be processing as I would imagine it will take some time to amend all open jobs...
> > >
> > > Michael
> > >
> > > --- In vantage@yahoogroups.com, "Linda Lowney" <llowney@> wrote:
> > > >
> > > > Hi
> > > >
> > > >
> > > >
> > > > Unknown or ambiguous table JobhHead. (725) - it looks like you have an
> > > > extra "h" in JobHead.
> > > >
> > > >
> > > >
> > > > Linda
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> > > > Of michael.hutcheson@
> > > > Sent: Thursday, November 26, 2009 9:57 AM
> > > > To: vantage@yahoogroups.com
> > > > Subject: [Vantage] Re: Mass lock qty on Jobs
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > Yeah,
> > > >
> > > > I tried this:
> > > >
> > > > for each JobhHead where JobHead.JobClosed = FALSE no-lock:
> > > > if available JobHead then do:
> > > > Run lib\UpdateTableBuffer.p(input BUFFER JobHead:HANDLE,
> > > > 'LockedQty',True).
> > > > End.
> > > > End
> > > >
> > > > But receive this:
> > > > Error Detail
> > > > ============
> > > > Unknown or ambiguous table JobhHead. (725)
> > > > ** Could not understand line 21. (196)
> > > >
> > > > Michael
> > > >
> > > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> > > > "Linda Lowney" <llowney@> wrote:
> > > > >
> > > > > Did you try removing the quotes around False ---- ttJobHead.JobClosed
> > > > =
> > > > > False no-lock:
> > > > >
> > > > >
> > > > >
> > > > > Linda
> > > > >
> > > > >
> > > > >
> > > > > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > > [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> > > > Behalf
> > > > > Of michael.hutcheson@
> > > > > Sent: Thursday, November 26, 2009 9:36 AM
> > > > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > > > Subject: [Vantage] Re: Mass lock qty on Jobs
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > Sorry, should be:
> > > > >
> > > > > For each ttjobhead where ttjobhead.RowMod = 'A' or ttjobhead.RowMod =
> > > > > 'U' and ttjobhead.JobClosed = 'False' no-lock:
> > > > > If available ttJobhead then do:
> > > > > Run lib\UpdateTableBuffer.p(input BUFFER
> > > > > ttJobHead:HANDLE,'LockedQty',True).
> > > > > End.
> > > > >
> > > > > Still not working though
> > > > >
> > > > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > > <mailto:vantage%40yahoogroups.com> ,
> > > > > "michael.hutcheson@" <michael.hutcheson@> wrote:
> > > > > >
> > > > > > Hello,
> > > > > >
> > > > > > Tried this:
> > > > > >
> > > > > > For each ttjobhead where ttjobhead.RowMod = 'A' or ttjobhead.RowMod
> > > > =
> > > > > 'U' and ttjobhead.LockedQty = 'False' no-lock:
> > > > > > If available ttJobhead then do:
> > > > > > Run lib\UpdateTableBuffer.p(input BUFFER
> > > > > ttJobHead:HANDLE,'LockedQty',True).
> > > > > > End.
> > > > > >
> > > > > > But received:
> > > > > >
> > > > > > Error Detail
> > > > > > ============
> > > > > > ** Incompatible data types in expression or assignment. (223)
> > > > > > ** Could not understand line 21. (196)
> > > > > >
> > > > > > Think its going to be a process of elimination!!
> > > > > >
> > > > > > Michael
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > > <mailto:vantage%40yahoogroups.com> ,
> > > > > "Linda Lowney" <llowney@> wrote:
> > > > > > >
> > > > > > > Hi,
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > Try removing the quotes around False and True.
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > Linda
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > 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 michael.hutcheson@
> > > > > > > Sent: Thursday, November 26, 2009 8:17 AM
> > > > > > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > > <mailto:vantage%40yahoogroups.com>
> > > > > > > Subject: [Vantage] Re: Mass lock qty on Jobs
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > Hello,
> > > > > > >
> > > > > > > I tried:
> > > > > > >
> > > > > > > find first ttjobhead where ttjobhead.rowmod = 'A' or
> > > > > ttjobhead.rowmod =
> > > > > > > 'U' no-error.
> > > > > > > if ttjobhead.jobclosed = 'False' then do:
> > > > > > > assign ttjobhead.lockedqty = 'TRUE'
> > > > > > > End
> > > > > > >
> > > > > > > But got:
> > > > > > >
> > > > > > > Error Detail
> > > > > > > ============
> > > > > > > ** Incompatible data types in expression or assignment. (223)
> > > > > > > ** Could not understand line 22. (198)
> > > > > > >
> > > > > > > Also tried:
> > > > > > >
> > > > > > > find first ttjobhead where ttjobhead.rowmod = 'A' or
> > > > > ttjobhead.rowmod =
> > > > > > > 'U' and ttjobhead.jobclosed = 'FALSE' no-error.
> > > > > > > if available ttjobhead then do:
> > > > > > > assign ttjobhead.lockedqty = 'TRUE'
> > > > > > > End
> > > > > > >
> > > > > > > But got:
> > > > > > >
> > > > > > > Error Detail
> > > > > > > ============
> > > > > > > ** Incompatible data types in expression or assignment. (223)
> > > > > > > ** Could not understand line 21. (196)
> > > > > > >
> > > > > > > Michael
> > > > > > >
> > > > > > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > > <mailto:vantage%40yahoogroups.com>
> > > > > <mailto:vantage%40yahoogroups.com> ,
> > > > > > > "bw2868bond" <bwalker@> wrote:
> > > > > > > >
> > > > > > > > Try
> > > > > > > >
> > > > > > > > if ttjobhead.JobClosed = 'FALSE' then do:
> > > > > > > >
> > > > > > > > I think the AVAILABLE keyword is what is blowing it up
> > > > > > > >
> > > > > > > > --- In vantage@yahoogroups.com
> > > > <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
> > > > > <mailto:vantage%40yahoogroups.com> ,
> > > > > > > "michael.hutcheson@" <michael.hutcheson@> wrote:
> > > > > > > > >
> > > > > > > > > I created a preprocessing action on the Job Entry update.
> > > > > > > > >
> > > > > > > > > action is to execute 4 gl code:
> > > > > > > > >
> > > > > > > > > find first ttjobhead no-lock no-error.
> > > > > > > > >
> > > > > > > > > if available ttjobhead.jobclosed = 'FALSE' then do:
> > > > > > > > >
> > > > > > > > > ttjobhead.LockedQty = 'TRUE'
> > > > > > > > >
> > > > > > > > > End
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > However, I keep receiving the following error:
> > > > > > > > >
> > > > > > > > > Error Detail
> > > > > > > > > ============
> > > > > > > > > Unknown database name ttjobhead. (855)
> > > > > > > > > Unknown or ambiguous table jobclosed. (725)
> > > > > > > > > ** Could not understand line 23. (198)
> > > > > > > > >
> > > > > > > > > Any ideas?
> > > > > > > > >
> > > > > > > > > Michael.
> > > > > > > > >
> > > > > > > > > --- In vantage@yahoogroups.com
> > > > <mailto:vantage%40yahoogroups.com>
> > > > > <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
> > > > ,
> > > > > > > "michael.hutcheson@" <michael.hutcheson@> wrote:
> > > > > > > > > >
> > > > > > > > > > Hello,
> > > > > > > > > >
> > > > > > > > > > I need to mass lock the qty on all open jobs.
> > > > > > > > > >
> > > > > > > > > > I created a BPM on the JobEntry\GetNewJobHead method.
> > > > > > > > > >
> > > > > > > > > > On the condition (pre processing) I added:
> > > > > > > > > >
> > > > > > > > > > the Jobhead.JobClosed field of all rows is equal to the
> > > > FALSE
> > > > > > > value
> > > > > > > > > >
> > > > > > > > > > Then on the Actions I created:
> > > > > > > > > >
> > > > > > > > > > set the JobHead.LockedQty field of all rows to the TRUE
> > > > value
> > > > > > > > > >
> > > > > > > > > > I also put the above action in the post processing as well.
> > > > > > > > > >
> > > > > > > > > > I went into job entry, created a test job and presto the
> > > > > Locked
> > > > > > > Qty is ticked, however, all the other jobs still have the locked
> > > > qty
> > > > > > > unticked - how do I do this for all Jobs??
> > > > > > > > > >
> > > > > > > > > > Thanks for any help
> > > > > > > > > >
> > > > > > > > > > Michael Hutcheson
> > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > [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]
> > > >
> > >
> >
>
Ok, I've got it to validate. When I run it, Vantage hangs for about 5 mins, comes back to life but all of the jobs don't have a locked qty.....


Michael

--- In vantage@yahoogroups.com, "michael.hutcheson@..." <michael.hutcheson@...> wrote:
>
> Hello,
>
> Thanks for this.
>
> Tried the code but received the following when validating:
>
> The following application error was encountered:
>
> ** Unknown table name er. (200)
> ** Could not understand line 22. (196)
>
> Michael
>
>
>
>
> --- In vantage@yahoogroups.com, "deleoye" <deleoye@> wrote:
> >
> >
> >
> > You don't need the "If AVAILABLE" condition with the "For Each" loop.
> >
> > Try:
> >
> > for each JobHead where JobHead.JobClosed = FALSE no-lock:
> > Run lib\UpdateTableBuffer.p(input BUFFER JobHead:HANDLE, 'LockedQty',True).
> > End.
> >
> > Dele Oyebande
> >
> > --- In vantage@yahoogroups.com, "michael.hutcheson@" <michael.hutcheson@> wrote:
> > >
> > > Although the below code is validated, it still does not lock the qty's of all open jobs. When you click save, ie. go through the job entry.update methods, its hangs for approx 4 mins, but then does not actually do any thing.
> > >
> > > Any ideas?
> > >
> > > Michael
> > >
> > > --- In vantage@yahoogroups.com, "michael.hutcheson@" <michael.hutcheson@> wrote:
> > > >
> > > > Yes so I do!!
> > > >
> > > > Changed it to:
> > > >
> > > > for each JobHead where JobHead.JobClosed = FALSE no-lock:
> > > > if available JobHead then do:
> > > > Run lib\UpdateTableBuffer.p(input BUFFER JobHead:HANDLE, 'LockedQty',True).
> > > > End.
> > > > End.
> > > >
> > > > It now validates!!! Just tried to run it and vantage hangs, but it may be processing as I would imagine it will take some time to amend all open jobs...
> > > >
> > > > Michael
> > > >
> > > > --- In vantage@yahoogroups.com, "Linda Lowney" <llowney@> wrote:
> > > > >
> > > > > Hi
> > > > >
> > > > >
> > > > >
> > > > > Unknown or ambiguous table JobhHead. (725) - it looks like you have an
> > > > > extra "h" in JobHead.
> > > > >
> > > > >
> > > > >
> > > > > Linda
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> > > > > Of michael.hutcheson@
> > > > > Sent: Thursday, November 26, 2009 9:57 AM
> > > > > To: vantage@yahoogroups.com
> > > > > Subject: [Vantage] Re: Mass lock qty on Jobs
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > Yeah,
> > > > >
> > > > > I tried this:
> > > > >
> > > > > for each JobhHead where JobHead.JobClosed = FALSE no-lock:
> > > > > if available JobHead then do:
> > > > > Run lib\UpdateTableBuffer.p(input BUFFER JobHead:HANDLE,
> > > > > 'LockedQty',True).
> > > > > End.
> > > > > End
> > > > >
> > > > > But receive this:
> > > > > Error Detail
> > > > > ============
> > > > > Unknown or ambiguous table JobhHead. (725)
> > > > > ** Could not understand line 21. (196)
> > > > >
> > > > > Michael
> > > > >
> > > > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> > > > > "Linda Lowney" <llowney@> wrote:
> > > > > >
> > > > > > Did you try removing the quotes around False ---- ttJobHead.JobClosed
> > > > > =
> > > > > > False no-lock:
> > > > > >
> > > > > >
> > > > > >
> > > > > > Linda
> > > > > >
> > > > > >
> > > > > >
> > > > > > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > > > [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> > > > > Behalf
> > > > > > Of michael.hutcheson@
> > > > > > Sent: Thursday, November 26, 2009 9:36 AM
> > > > > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > > > > Subject: [Vantage] Re: Mass lock qty on Jobs
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > > Sorry, should be:
> > > > > >
> > > > > > For each ttjobhead where ttjobhead.RowMod = 'A' or ttjobhead.RowMod =
> > > > > > 'U' and ttjobhead.JobClosed = 'False' no-lock:
> > > > > > If available ttJobhead then do:
> > > > > > Run lib\UpdateTableBuffer.p(input BUFFER
> > > > > > ttJobHead:HANDLE,'LockedQty',True).
> > > > > > End.
> > > > > >
> > > > > > Still not working though
> > > > > >
> > > > > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > > > <mailto:vantage%40yahoogroups.com> ,
> > > > > > "michael.hutcheson@" <michael.hutcheson@> wrote:
> > > > > > >
> > > > > > > Hello,
> > > > > > >
> > > > > > > Tried this:
> > > > > > >
> > > > > > > For each ttjobhead where ttjobhead.RowMod = 'A' or ttjobhead.RowMod
> > > > > =
> > > > > > 'U' and ttjobhead.LockedQty = 'False' no-lock:
> > > > > > > If available ttJobhead then do:
> > > > > > > Run lib\UpdateTableBuffer.p(input BUFFER
> > > > > > ttJobHead:HANDLE,'LockedQty',True).
> > > > > > > End.
> > > > > > >
> > > > > > > But received:
> > > > > > >
> > > > > > > Error Detail
> > > > > > > ============
> > > > > > > ** Incompatible data types in expression or assignment. (223)
> > > > > > > ** Could not understand line 21. (196)
> > > > > > >
> > > > > > > Think its going to be a process of elimination!!
> > > > > > >
> > > > > > > Michael
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > > > <mailto:vantage%40yahoogroups.com> ,
> > > > > > "Linda Lowney" <llowney@> wrote:
> > > > > > > >
> > > > > > > > Hi,
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > Try removing the quotes around False and True.
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > Linda
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > 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 michael.hutcheson@
> > > > > > > > Sent: Thursday, November 26, 2009 8:17 AM
> > > > > > > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > > > <mailto:vantage%40yahoogroups.com>
> > > > > > > > Subject: [Vantage] Re: Mass lock qty on Jobs
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > Hello,
> > > > > > > >
> > > > > > > > I tried:
> > > > > > > >
> > > > > > > > find first ttjobhead where ttjobhead.rowmod = 'A' or
> > > > > > ttjobhead.rowmod =
> > > > > > > > 'U' no-error.
> > > > > > > > if ttjobhead.jobclosed = 'False' then do:
> > > > > > > > assign ttjobhead.lockedqty = 'TRUE'
> > > > > > > > End
> > > > > > > >
> > > > > > > > But got:
> > > > > > > >
> > > > > > > > Error Detail
> > > > > > > > ============
> > > > > > > > ** Incompatible data types in expression or assignment. (223)
> > > > > > > > ** Could not understand line 22. (198)
> > > > > > > >
> > > > > > > > Also tried:
> > > > > > > >
> > > > > > > > find first ttjobhead where ttjobhead.rowmod = 'A' or
> > > > > > ttjobhead.rowmod =
> > > > > > > > 'U' and ttjobhead.jobclosed = 'FALSE' no-error.
> > > > > > > > if available ttjobhead then do:
> > > > > > > > assign ttjobhead.lockedqty = 'TRUE'
> > > > > > > > End
> > > > > > > >
> > > > > > > > But got:
> > > > > > > >
> > > > > > > > Error Detail
> > > > > > > > ============
> > > > > > > > ** Incompatible data types in expression or assignment. (223)
> > > > > > > > ** Could not understand line 21. (196)
> > > > > > > >
> > > > > > > > Michael
> > > > > > > >
> > > > > > > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > > > <mailto:vantage%40yahoogroups.com>
> > > > > > <mailto:vantage%40yahoogroups.com> ,
> > > > > > > > "bw2868bond" <bwalker@> wrote:
> > > > > > > > >
> > > > > > > > > Try
> > > > > > > > >
> > > > > > > > > if ttjobhead.JobClosed = 'FALSE' then do:
> > > > > > > > >
> > > > > > > > > I think the AVAILABLE keyword is what is blowing it up
> > > > > > > > >
> > > > > > > > > --- In vantage@yahoogroups.com
> > > > > <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
> > > > > > <mailto:vantage%40yahoogroups.com> ,
> > > > > > > > "michael.hutcheson@" <michael.hutcheson@> wrote:
> > > > > > > > > >
> > > > > > > > > > I created a preprocessing action on the Job Entry update.
> > > > > > > > > >
> > > > > > > > > > action is to execute 4 gl code:
> > > > > > > > > >
> > > > > > > > > > find first ttjobhead no-lock no-error.
> > > > > > > > > >
> > > > > > > > > > if available ttjobhead.jobclosed = 'FALSE' then do:
> > > > > > > > > >
> > > > > > > > > > ttjobhead.LockedQty = 'TRUE'
> > > > > > > > > >
> > > > > > > > > > End
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > However, I keep receiving the following error:
> > > > > > > > > >
> > > > > > > > > > Error Detail
> > > > > > > > > > ============
> > > > > > > > > > Unknown database name ttjobhead. (855)
> > > > > > > > > > Unknown or ambiguous table jobclosed. (725)
> > > > > > > > > > ** Could not understand line 23. (198)
> > > > > > > > > >
> > > > > > > > > > Any ideas?
> > > > > > > > > >
> > > > > > > > > > Michael.
> > > > > > > > > >
> > > > > > > > > > --- In vantage@yahoogroups.com
> > > > > <mailto:vantage%40yahoogroups.com>
> > > > > > <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
> > > > > ,
> > > > > > > > "michael.hutcheson@" <michael.hutcheson@> wrote:
> > > > > > > > > > >
> > > > > > > > > > > Hello,
> > > > > > > > > > >
> > > > > > > > > > > I need to mass lock the qty on all open jobs.
> > > > > > > > > > >
> > > > > > > > > > > I created a BPM on the JobEntry\GetNewJobHead method.
> > > > > > > > > > >
> > > > > > > > > > > On the condition (pre processing) I added:
> > > > > > > > > > >
> > > > > > > > > > > the Jobhead.JobClosed field of all rows is equal to the
> > > > > FALSE
> > > > > > > > value
> > > > > > > > > > >
> > > > > > > > > > > Then on the Actions I created:
> > > > > > > > > > >
> > > > > > > > > > > set the JobHead.LockedQty field of all rows to the TRUE
> > > > > value
> > > > > > > > > > >
> > > > > > > > > > > I also put the above action in the post processing as well.
> > > > > > > > > > >
> > > > > > > > > > > I went into job entry, created a test job and presto the
> > > > > > Locked
> > > > > > > > Qty is ticked, however, all the other jobs still have the locked
> > > > > qty
> > > > > > > > unticked - how do I do this for all Jobs??
> > > > > > > > > > >
> > > > > > > > > > > Thanks for any help
> > > > > > > > > > >
> > > > > > > > > > > Michael Hutcheson
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > [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]
> > > > >
> > > >
> > >
> >
>