Got it .... The answer is simply STRING(Orderhed.Ordernum) = UD09.key1
Tom Christie | Information Technology Manager | AGM Container Controls, Inc.<http://www.agmcontainer.com/> | tchristie@...<mailto:tchristie@...> | t: 520.881.2130 ext 2176
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, July 9, 2014 11:44 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BPM Query problem comparing a UD key (string) to Ordernum (integer)
Okay, I need this query to work. The problem is that ordernum is a number and key1 is a string. What do I need to do to make this function?
[cid:image001.png@01CF9B6B.1C1BBEA0]
Regards,
Tom Christie | Information Technology Manager | AGM Container Controls, Inc.<http://www.agmcontainer.com/> | tchristie@...<mailto:tchristie@...> | t: 520.881.2130 ext 2176
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
Tom Christie | Information Technology Manager | AGM Container Controls, Inc.<http://www.agmcontainer.com/> | tchristie@...<mailto:tchristie@...> | t: 520.881.2130 ext 2176
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, July 9, 2014 11:44 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BPM Query problem comparing a UD key (string) to Ordernum (integer)
Okay, I need this query to work. The problem is that ordernum is a number and key1 is a string. What do I need to do to make this function?
[cid:image001.png@01CF9B6B.1C1BBEA0]
Regards,
Tom Christie | Information Technology Manager | AGM Container Controls, Inc.<http://www.agmcontainer.com/> | tchristie@...<mailto:tchristie@...> | t: 520.881.2130 ext 2176
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]