ABL Code help Blank Title 127872

Yahoo Archive
1

Appreciate the thought but us working stiffs don't get to go.  I believe Encompass will be there with a booth or something, I'm sure someone there will take the drink at least for me.


Jim Kinneman

Encompass Solutions, Inc.

2

Can someone tell me what is wrong here.

 

I did a BPM Hold on the customer for Sales Orders.   The bpm checks for the customer and then puts the SO on hold and also created a BPM Hold.  Now I am try to clear it.  So when I delete the BPM Hold it will "unhold" the SO.

 

 

The Condition works since I see the Info Message, but the code below gives me an error during PreProc.

 

for each ttBpHoldAttachment no-lock where ttBpHoldAttachment.RowMod = "D":

 

find first orderhed where (orderhed.Company = ttBpHoldAttachment.Company and Orderhed.OrderNum = ttBpHoldAttachment.key1) no-lock.

 

if avail orderhed then do:

assign orderhed.OrderHeld = false.

end.

end.

 

 

ERROR:

 

** Incompatible data types in expression or assignment. (223)

** D:\EpicorData\115230598671925102917521718912224583146.p Could not understand line 14. (196)

 

 

Miguel A. Santillan

ERP Analyst

Compass Manufacturing Systems

510-661-6666  Office

510-656-0603  Fax

msantillan@...

 

3
Key1 and OrdeNum are different data types convert key1 Â to an int or ordernum to a string.



Jose C Gomez
Software Engineer



T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com

     Â


Quis custodiet ipsos custodes?


On Thu, Jan 23, 2014 at 7:42 PM, Miguel Santillan <msantillan@...> wrote:

 
<div>
  
  
  <p>

Can someone tell me what is wrong here.

Â

I did a BPM Hold on the customer for Sales Orders.  The bpm checks for the customer and then puts the SO on hold and also created a BPM Hold. Now I am try to clear it. So when I delete the BPM Hold it will "unhold" the SO.

Â

Â

The Condition works since I see the Info Message, but the code below gives me an error during PreProc.

Â

for each ttBpHoldAttachment no-lock where ttBpHoldAttachment.RowMod = "D":

Â

find first orderhed where (orderhed.Company = ttBpHoldAttachment.Company and Orderhed.OrderNum = ttBpHoldAttachment.key1) no-lock.

Â

if avail orderhed then do:

assign orderhed.OrderHeld = false.

end.

end.

Â

Â

ERROR:

Â

** Incompatible data types in expression or assignment. (223)

** D:\EpicorData\115230598671925102917521718912224583146.p Could not understand line 14. (196)

Â

Â

Miguel A. Santillan

ERP Analyst

Compass Manufacturing Systems

510-661-6666Â Office

510-656-0603Â Fax

msantillan@...

 

</div>
 


<div style="color:#fff;min-height:0;"></div>

4

Order num is a number keyX is usually a character type



Sent from my Atari 600



-----Original Message-----

From: Miguel Santillan [msantillan@…]

Received: Thursday, 23 Jan 2014, 18:42

To: vantage@yahoogroups.com [vantage@yahoogroups.com]

Subject: [Vantage] ABL Code help



 

Can someone tell me what is wrong here.

 

I did a BPM Hold on the customer for Sales Orders.   The bpm checks for the customer and then puts the SO on hold and also created a BPM Hold.  Now I am try to clear it.  So when I delete the BPM Hold it will "unhold" the SO.

 

 

The Condition works since I see the Info Message, but the code below gives me an error during PreProc.

 

for each ttBpHoldAttachment no-lock where ttBpHoldAttachment.RowMod = "D":

 

find first orderhed where (orderhed.Company = ttBpHoldAttachment.Company and Orderhed.OrderNum = ttBpHoldAttachment.key1) no-lock.

 

if avail orderhed then do:

assign orderhed.OrderHeld = false.

end.

end.

 

 

ERROR:

 

** Incompatible data types in expression or assignment. (223)

** D:\EpicorData\115230598671925102917521718912224583146.p Could not understand line 14. (196)

 

 

Miguel A. Santillan

ERP Analyst

Compass Manufacturing Systems

510-661-6666  Office

510-656-0603  Fax

msantillan@...

 

5

Change find first orderhed where (orderhed.Company = ttBpHoldAttachment.Company and Orderhed.OrderNum = ttBpHoldAttachment.key1) no-lock.


to

find first orderhed where (orderhed.Company = ttBpHoldAttachment.Company and Orderhed.OrderNum = integer(ttBpHoldAttachment.key1)) no-lock.  Notice the integer function on key1.


Jim Kinneman

Encompass Solutions, Inc

6
You may also have to remove the no-lock on your find first.

Steven G.


On Friday, January 24, 2014 9:29 AM, "jckinneman@..." <jckinneman@...> wrote:
  
<div id="ygrps-yiv-454906687yiv6890985817ygrp-text">
  
  
  <div>Change find first orderhed where (orderhed.Company = ttBpHoldAttachment.Company

and Orderhed.OrderNum = ttBpHoldAttachment.key1) no-lock.


to
find first orderhed where (orderhed.Company = ttBpHoldAttachment.Company
and Orderhed.OrderNum = integer(ttBpHoldAttachment.key1)) no-lock.  Notice the integer function on key1.

Jim Kinneman
Encompass Solutions, Inc

</div>
 


<div style="color:#fff;height:0;"></div></div>
#ygrps-yiv-454906687 #ygrps-yiv-454906687yiv6890985817 #ygrps-yiv-454906687yiv6890985817 -- #ygrps-yiv-454906687yiv6890985817ygrp-mkp { border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}

#ygrps-yiv-454906687 #ygrps-yiv-454906687yiv6890985817 #ygrps-yiv-454906687yiv6890985817ygrp-mkp hr {
border:1px solid #d8d8d8;}

#ygrps-yiv-454906687 #ygrps-yiv-454906687yiv6890985817 #ygrps-yiv-454906687yiv6890985817ygrp-mkp #ygrps-yiv-454906687yiv6890985817hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}

#ygrps-yiv-454906687 #ygrps-yiv-454906687yiv6890985817 #ygrps-yiv-454906687yiv6890985817ygrp-mkp #ygrps-yiv-454906687yiv6890985817ads {
margin-bottom:10px;}

#ygrps-yiv-454906687 #ygrps-yiv-454906687yiv6890985817 #ygrps-yiv-454906687yiv6890985817ygrp-mkp .ygrps-yiv-454906687yiv6890985817ad {
padding:0 0;}

#ygrps-yiv-454906687 #ygrps-yiv-454906687yiv6890985817 #ygrps-yiv-454906687yiv6890985817ygrp-mkp .ygrps-yiv-454906687yiv6890985817ad p {
margin:0;}

#ygrps-yiv-454906687 #ygrps-yiv-454906687yiv6890985817 #ygrps-yiv-454906687yiv6890985817ygrp-mkp .ygrps-yiv-454906687yiv6890985817ad a {
color:#0000ff;text-decoration:none;}
#ygrps-yiv-454906687 #ygrps-yiv-454906687yiv6890985817 #ygrps-yiv-454906687yiv6890985817ygrp-sponsor #ygrps-yiv-454906687yiv6890985817ygrp-lc {
font-family:Arial;}

#ygrps-yiv-454906687 #ygrps-yiv-454906687yiv6890985817 #ygrps-yiv-454906687yiv6890985817ygrp-sponsor #ygrps-yiv-454906687yiv6890985817ygrp-lc #ygrps-yiv-454906687yiv6890985817hd {
margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}

#ygrps-yiv-454906687 #ygrps-yiv-454906687yiv6890985817 #ygrps-yiv-454906687yiv6890985817ygrp-sponsor #ygrps-yiv-454906687yiv6890985817ygrp-lc .ygrps-yiv-454906687yiv6890985817ad {
margin-bottom:10px;padding:0 0;}

#ygrps-yiv-454906687 #ygrps-yiv-454906687yiv6890985817 #ygrps-yiv-454906687yiv6890985817actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#ygrps-yiv-454906687 #ygrps-yiv-454906687yiv6890985817 #ygrps-yiv-454906687yiv6890985817activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#ygrps-yiv-454906687 #ygrps-yiv-454906687yiv6890985817 #ygrps-yiv-454906687yiv6890985817activity span {
font-weight:700;}

#ygrps-yiv-454906687 #ygrps-yiv-454906687yiv6890985817 #ygrps-yiv-454906687yiv6890985817activity span:first-child {
text-transform:uppercase;}

#ygrps-yiv-454906687 #ygrps-yiv-454906687yiv6890985817 #ygrps-yiv-454906687yiv6890985817activity span a {
color:#5085b6;text-decoration:none;}

#ygrps-yiv-454906687 #ygrps-yiv-454906687yiv6890985817 #ygrps-yiv-454906687yiv6890985817activity span span {
color:#ff7900;}

#ygrps-yiv-454906687 #ygrps-yiv-454906687yiv6890985817 #ygrps-yiv-454906687yiv6890985817activity span .ygrps-yiv-454906687yiv6890985817underline {
text-decoration:underline;}

#ygrps-yiv-454906687 #ygrps-yiv-454906687yiv6890985817 .ygrps-yiv-454906687yiv6890985817attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}

#ygrps-yiv-454906687 #ygrps-yiv-454906687yiv6890985817 .ygrps-yiv-454906687yiv6890985817attach div a {
text-decoration:none;}

#ygrps-yiv-454906687 #ygrps-yiv-454906687yiv6890985817 .ygrps-yiv-454906687yiv6890985817attach img {
border:none;padding-right:5px;}

#ygrps-yiv-454906687 #ygrps-yiv-454906687yiv6890985817 .ygrps-yiv-454906687yiv6890985817attach label {
display:block;margin-bottom:5px;}

#ygrps-yiv-454906687 #ygrps-yiv-454906687yiv6890985817 .ygrps-yiv-454906687yiv6890985817attach label a {
text-decoration:none;}

#ygrps-yiv-454906687 #ygrps-yiv-454906687yiv6890985817 blockquote {
margin:0 0 0 4px;}

#ygrps-yiv-454906687 #ygrps-yiv-454906687yiv6890985817 .ygrps-yiv-454906687yiv6890985817bold {
font-family:Arial;font-size:13px;font-weight:700;}

#ygrps-yiv-454906687 #ygrps-yiv-454906687yiv6890985817 .ygrps-yiv-454906687yiv6890985817bold a {
text-decoration:none;}

#ygrps-yiv-454906687 #ygrps-yiv-454906687yiv6890985817 dd.ygrps-yiv-454906687yiv6890985817last p a {
font-family:Verdana;font-weight:700;}

#ygrps-yiv-454906687 #ygrps-yiv-454906687yiv6890985817 dd.ygrps-yiv-454906687yiv6890985817last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#ygrps-yiv-454906687 #ygrps-yiv-454906687yiv6890985817 dd.ygrps-yiv-454906687yiv6890985817last p span.ygrps-yiv-454906687yiv6890985817yshortcuts {
margin-right:0;}

#ygrps-yiv-454906687 #ygrps-yiv-454906687yiv6890985817 div.ygrps-yiv-454906687yiv6890985817attach-table div div a {
text-decoration:none;}

#ygrps-yiv-454906687 #ygrps-yiv-454906687yiv6890985817 div.ygrps-yiv-454906687yiv6890985817attach-table {
width:400px;}

#ygrps-yiv-454906687 #ygrps-yiv-454906687yiv6890985817 div.ygrps-yiv-454906687yiv6890985817file-title a, #ygrps-yiv-454906687 #ygrps-yiv-454906687yiv6890985817 div.ygrps-yiv-454906687yiv6890985817file-title a:active, #ygrps-yiv-454906687 #ygrps-yiv-454906687yiv6890985817 div.ygrps-yiv-454906687yiv6890985817file-title a:hover, #ygrps-yiv-454906687 #ygrps-yiv-454906687yiv6890985817 div.ygrps-yiv-454906687yiv6890985817file-title a:visited {
text-decoration:none;}

#ygrps-yiv-454906687 #ygrps-yiv-454906687yiv6890985817 div.ygrps-yiv-454906687yiv6890985817photo-title a, #ygrps-yiv-454906687 #ygrps-yiv-454906687yiv6890985817 div.ygrps-yiv-454906687yiv6890985817photo-title a:active, #ygrps-yiv-454906687 #ygrps-yiv-454906687yiv6890985817 div.ygrps-yiv-454906687yiv6890985817photo-title a:hover, #ygrps-yiv-454906687 #ygrps-yiv-454906687yiv6890985817 div.ygrps-yiv-454906687yiv6890985817photo-title a:visited {
text-decoration:none;}

#ygrps-yiv-454906687 #ygrps-yiv-454906687yiv6890985817 div#ygrps-yiv-454906687yiv6890985817ygrp-mlmsg #ygrps-yiv-454906687yiv6890985817ygrp-msg p a span.ygrps-yiv-454906687yiv6890985817yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#ygrps-yiv-454906687 #ygrps-yiv-454906687yiv6890985817 .ygrps-yiv-454906687yiv6890985817green {
color:#628c2a;}

#ygrps-yiv-454906687 #ygrps-yiv-454906687yiv6890985817 .ygrps-yiv-454906687yiv6890985817MsoNormal {
margin:0 0 0 0;}

#ygrps-yiv-454906687 #ygrps-yiv-454906687yiv6890985817 o {
font-size:0;}

#ygrps-yiv-454906687 #ygrps-yiv-454906687yiv6890985817 #ygrps-yiv-454906687yiv6890985817photos div {
float:left;width:72px;}

#ygrps-yiv-454906687 #ygrps-yiv-454906687yiv6890985817 #ygrps-yiv-454906687yiv6890985817photos div div {
border:1px solid #666666;height:62px;overflow:hidden;width:62px;}

#ygrps-yiv-454906687 #ygrps-yiv-454906687yiv6890985817 #ygrps-yiv-454906687yiv6890985817photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#ygrps-yiv-454906687 #ygrps-yiv-454906687yiv6890985817 #ygrps-yiv-454906687yiv6890985817reco-category {
font-size:77%;}

#ygrps-yiv-454906687 #ygrps-yiv-454906687yiv6890985817 #ygrps-yiv-454906687yiv6890985817reco-desc {
font-size:77%;}

#ygrps-yiv-454906687 #ygrps-yiv-454906687yiv6890985817 .ygrps-yiv-454906687yiv6890985817replbq {
margin:4px;}

#ygrps-yiv-454906687 #ygrps-yiv-454906687yiv6890985817 #ygrps-yiv-454906687yiv6890985817ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#ygrps-yiv-454906687 #ygrps-yiv-454906687yiv6890985817 #ygrps-yiv-454906687yiv6890985817ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}

#ygrps-yiv-454906687 #ygrps-yiv-454906687yiv6890985817 #ygrps-yiv-454906687yiv6890985817ygrp-mlmsg table {
font-size:inherit;font:100%;}

#ygrps-yiv-454906687 #ygrps-yiv-454906687yiv6890985817 #ygrps-yiv-454906687yiv6890985817ygrp-mlmsg select, #ygrps-yiv-454906687 #ygrps-yiv-454906687yiv6890985817 input, #ygrps-yiv-454906687 #ygrps-yiv-454906687yiv6890985817 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#ygrps-yiv-454906687 #ygrps-yiv-454906687yiv6890985817 #ygrps-yiv-454906687yiv6890985817ygrp-mlmsg pre, #ygrps-yiv-454906687 #ygrps-yiv-454906687yiv6890985817 code {
font:115% monospace;}

#ygrps-yiv-454906687 #ygrps-yiv-454906687yiv6890985817 #ygrps-yiv-454906687yiv6890985817ygrp-mlmsg * {
line-height:1.22em;}

#ygrps-yiv-454906687 #ygrps-yiv-454906687yiv6890985817 #ygrps-yiv-454906687yiv6890985817ygrp-mlmsg #ygrps-yiv-454906687yiv6890985817logo {
padding-bottom:10px;}

#ygrps-yiv-454906687 #ygrps-yiv-454906687yiv6890985817 #ygrps-yiv-454906687yiv6890985817ygrp-msg p a {
font-family:Verdana;}

#ygrps-yiv-454906687 #ygrps-yiv-454906687yiv6890985817 #ygrps-yiv-454906687yiv6890985817ygrp-msg p#ygrps-yiv-454906687yiv6890985817attach-count span {
color:#1E66AE;font-weight:700;}

#ygrps-yiv-454906687 #ygrps-yiv-454906687yiv6890985817 #ygrps-yiv-454906687yiv6890985817ygrp-reco #ygrps-yiv-454906687yiv6890985817reco-head {
color:#ff7900;font-weight:700;}

#ygrps-yiv-454906687 #ygrps-yiv-454906687yiv6890985817 #ygrps-yiv-454906687yiv6890985817ygrp-reco {
margin-bottom:20px;padding:0px;}

#ygrps-yiv-454906687 #ygrps-yiv-454906687yiv6890985817 #ygrps-yiv-454906687yiv6890985817ygrp-sponsor #ygrps-yiv-454906687yiv6890985817ov li a {
font-size:130%;text-decoration:none;}

#ygrps-yiv-454906687 #ygrps-yiv-454906687yiv6890985817 #ygrps-yiv-454906687yiv6890985817ygrp-sponsor #ygrps-yiv-454906687yiv6890985817ov li {
font-size:77%;list-style-type:square;padding:6px 0;}

#ygrps-yiv-454906687 #ygrps-yiv-454906687yiv6890985817 #ygrps-yiv-454906687yiv6890985817ygrp-sponsor #ygrps-yiv-454906687yiv6890985817ov ul {
margin:0;padding:0 0 0 8px;}

#ygrps-yiv-454906687 #ygrps-yiv-454906687yiv6890985817 #ygrps-yiv-454906687yiv6890985817ygrp-text {
font-family:Georgia;}

#ygrps-yiv-454906687 #ygrps-yiv-454906687yiv6890985817 #ygrps-yiv-454906687yiv6890985817ygrp-text p {
margin:0 0 1em 0;}

#ygrps-yiv-454906687 #ygrps-yiv-454906687yiv6890985817 #ygrps-yiv-454906687yiv6890985817ygrp-text tt {
font-size:120%;}

#ygrps-yiv-454906687 #ygrps-yiv-454906687yiv6890985817 #ygrps-yiv-454906687yiv6890985817ygrp-vital ul li:last-child {
border-right:none !important;}
#ygrps-yiv-454906687



7

Thanks that let it validate the code.

 

The BPM does not uncheck the OrderHed.OrderHeld

 

In the Action, I have the info message display the correct SO that I want.  I then added the Info message in the ABL and is also displays the correct OrderNum and it shows that the Order is on hold.  But is does not change the flag on the SO.

 

Any ideas?

 

for each ttBpHoldAttachment no-lock where ttBpHoldAttachment.RowMod = "D":

 

find first orderhed where (orderhed.Company = ttBpHoldAttachment.Company and Orderhed.OrderNum = integer(ttBpHoldAttachment.key1)) no-lock.

 

if avail orderhed then do:

{lib/PublishInfoMsg.i &InfoMsg = "'Code works up to here '+ string(orderhed.ordernum) "}.

assign orderhed.OrderHeld = no.

end.

end.

 

Miguel A. Santillan

Compass Manufacturing Systems

510-661-6666  Office

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of jckinneman@...
Sent: Friday, January 24, 2014 6:29 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: ABL Code help

 

 

Change find first orderhed where (orderhed.Company = ttBpHoldAttachment.Company and Orderhed.OrderNum = ttBpHoldAttachment.key1) no-lock.

 

to

find first orderhed where (orderhed.Company = ttBpHoldAttachment.Company and Orderhed.OrderNum = integer(ttBpHoldAttachment.key1)) no-lock.  Notice the integer function on key1.

 

Jim Kinneman

Encompass Solutions, Inc

8
While I believe assign is supposed to promote the no-lock to a lock you might need to put an exclusive lock on the table.

to keep the transaction to a minimum you can use a for first instead of find first. "For" supposedly runs faster

for first orderhed exclusive-lock where (orderhed.Company = ttBpHoldAttachment.Company and Orderhed.OrderNum = integer(ttBpHoldAttachment.key1)):

    assign orderhed.orderheld = no.
end.
9

I owe you a drink and a lap dance (not from me) at Insights!

 

Miguel A. Santillan

Compass Manufacturing Systems

510-661-6666  Office

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of jckinneman@...
Sent: Friday, January 24, 2014 10:27 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: ABL Code help

 

 

While I believe assign is supposed to promote the no-lock to a lock you might need to put an exclusive lock on the table.

to keep the transaction to a minimum you can use a for first instead of find first. "For" supposedly runs faster

for first orderhed exclusive-lock where (orderhed.Company = ttBpHoldAttachment.Company and Orderhed.OrderNum = integer(ttBpHoldAttachment.key1)):

    assign orderhed.orderheld = no.

end.