DMRHead does not seem to work either! whats the catch? i have also tried using the Execute 4GL Code and still no worky!
Code:
FOR EACH ttJobProd no-lock ,
EACH DMRHead WHERE (DMRHead.Company = ttJobProd.Company AND DMRHead.JobNum = ttJobProd.JobNum) no-lock:
Code:
FOR EACH ttJobProd no-lock ,
EACH DMRHead WHERE (DMRHead.Company = ttJobProd.Company AND DMRHead.JobNum = ttJobProd.JobNum) no-lock:
--- In vantage@yahoogroups.com, Rob Bucek <rbucek@...> wrote:
>
> I thought the dmr.actn jobnum was for WHERE you dispositioned the job to... try dmrhead.jobnum
>
> Rob Bucek
> Production Control Manager
> PH: (715) 284-5376 ext 311
> Mobile: (715)896-0590
> FAX: (715)284-4084
> [Description: cid:1.234354861@...]<http://www.dsmfg.com/>
> (Click the logo to view our site)<http://www.dsmfg.com/>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of vacortes21
> Sent: Friday, June 22, 2012 5:33 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Filter Jobs with a DMR
>
>
>
> i have a BPM using the Method "JobEntry.ChangeJobProdMakeToStockQty"
> with a Pre-Processing Condition "the ttJobProd.MakeToStockQty field has been changed from any to any" AND "number of rows in the 'Design' query is not less than 1. (which i want to only look for Jobs in the DMRActn table but i cant make it work.)
>
> this is my code:
>
> FOR EACH ttJObProd WHERE ttJObProd.RowMod= "U" no-lock ,
> EACH DMRActn WHERE DMRActn.Company = ttJObProd.Company AND
> DMRActn.JobNum = ttJobProd.JobNum no-lock:
>
> My Action is triggered when the qty is changed on any Job! not just jobs that have a DMR.
>
> any hints or advice is appreciated! thanks
>
>
>
> [Non-text portions of this message have been removed]
>