BPM data directive query not validating

Yahoo Archive
1
It actually all triggers at the same time, though the IN-Transaction allows you to modify the incoming data while the Standard Doesn't.Â


Jose C Gomez
Software Engineer



T: 904.469.1524 mobile

E: jose@...
http://www.josecgomez.com

     Â


Quis custodiet ipsos custodes?


On Fri, Jun 6, 2014 at 11:11 AM, marvinhorst@... [vantage] <vantage@yahoogroups.com> wrote:

 
<div>
  
  
  <p>Thanks Jose</p><div><br></div><div><div>A Standard Directive condition executes <span style="font-weight:bold;">after </span>the data is written to the progress database?<br><div><br><br>---In <a rel="nofollow" target="_blank" href="mailto:vantage@yahoogroups.com">vantage@yahoogroups.com</a>, &lt;jose@...&gt; wrote :<br>


you neeed a for each for your TT table you can't just address the record directly without being in a "loop" also don't do this "In-Transaction" those are only for when you are modifying data. Use a Standard Directive for sending email.



Jose C Gomez
Software Engineer



T: 904.469.1524 mobile

E: jose@...

http://www.josecgomez.com
     Â


Quis custodiet ipsos custodes?


On Fri, Jun 6, 2014 at 10:13 AM, marvinhorst@... [vantage] <vantage@yahoogroups.com> wrote:
Â

I am creating an In-Transaction Data Directive for the PickedOrders table to generate an email notification when the first item is picked for an Order. For a condition I'm using:

 number of rows in the 'Picked Lines' query is less than 1

This is my query definition.

for each PickedOrders no-lock where PickedOrders.OrderNum = ttPickedOrders.OrderNum and PickedOrders.Company = Constants.CurrentCompany


Which generates this error when it's validated.
ttPickedOrders OrderNum must be a quoted constant or an unabbreviated unambiguous buffer/field reference for buffers known to query . (7328)

If I single quote ttPickedOrders.OrderNum it validates but my query will be using the field name as a text string instead of comparing against the field value.
for each PickedOrders no-lock where PickedOrders.OrderNum = 'ttPickedOrders.OrderNum' and PickedOrders.Company = Constants.CurrentCompany

Why is my query not validating?


</div><div class="ygrps-yiv-152245316">
 


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

2

I am creating an In-Transaction Data Directive for the PickedOrders table to generate an email notification when the first item is picked for an Order. For a condition I'm using:

 number of rows in the 'Picked Lines' query is less than 1

This is my query definition.

for each PickedOrders no-lock where PickedOrders.OrderNum = ttPickedOrders.OrderNum and PickedOrders.Company = Constants.CurrentCompany


Which generates this error when it's validated.
ttPickedOrders OrderNum must be a quoted constant or an unabbreviated unambiguous buffer/field reference for buffers known to query . (7328)

If I single quote ttPickedOrders.OrderNum it validates but my query will be using the field name as a text string instead of comparing against the field value.
for each PickedOrders no-lock where PickedOrders.OrderNum = 'ttPickedOrders.OrderNum' and PickedOrders.Company = Constants.CurrentCompany

Why is my query not validating?
3
you neeed a for each for your TT table you can't just address the record directly without being in a "loop" also don't do this "In-Transaction" those are only for when you are modifying data. Use a Standard Directive for sending email.


Jose C Gomez
Software Engineer



T: 904.469.1524 mobile

E: jose@...
http://www.josecgomez.com

     Â


Quis custodiet ipsos custodes?


On Fri, Jun 6, 2014 at 10:13 AM, marvinhorst@... [vantage] <vantage@yahoogroups.com> wrote:

 
<div>
  
  
  <p></p><p><span>I am creating an In-Transaction Data Directive for the PickedOrders table to generate an email notification when the first item is picked for an Order. For a condition I&#39;m using:</span></p><blockquote style="padding:0px;">

 number of rows in the 'Picked Lines' query is less than 1

This is my query definition.

for each PickedOrders no-lock where PickedOrders.OrderNum = ttPickedOrders.OrderNum and PickedOrders.Company = Constants.CurrentCompany


Which generates this error when it's validated.

ttPickedOrders OrderNum must be a quoted constant or an unabbreviated unambiguous buffer/field reference for buffers known to query . (7328)

If I single quote ttPickedOrders.OrderNum it validates but my query will be using the field name as a text string instead of comparing against the field value.
for each PickedOrders no-lock where PickedOrders.OrderNum = 'ttPickedOrders.OrderNum' and PickedOrders.Company = Constants.CurrentCompany

Why is my query not validating?

</div>
 


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

4
Thanks Jose

A Standard Directive condition executes after the data is written to the progress database?


---In vantage@yahoogroups.com, <jose@...> wrote :

you neeed a for each for your TT table you can't just address the record directly without being in a "loop" also don't do this "In-Transaction" those are only for when you are modifying data. Use a Standard Directive for sending email.


Jose C Gomez
Software Engineer


T: 904.469.1524 mobile

Quis custodiet ipsos custodes?


On Fri, Jun 6, 2014 at 10:13 AM, marvinhorst@... [vantage] <vantage@yahoogroups.com> wrote:
 

I am creating an In-Transaction Data Directive for the PickedOrders table to generate an email notification when the first item is picked for an Order. For a condition I'm using:

 number of rows in the 'Picked Lines' query is less than 1

This is my query definition.

for each PickedOrders no-lock where PickedOrders.OrderNum = ttPickedOrders.OrderNum and PickedOrders.Company = Constants.CurrentCompany


Which generates this error when it's validated.
ttPickedOrders OrderNum must be a quoted constant or an unabbreviated unambiguous buffer/field reference for buffers known to query . (7328)

If I single quote ttPickedOrders.OrderNum it validates but my query will be using the field name as a text string instead of comparing against the field value.
for each PickedOrders no-lock where PickedOrders.OrderNum = 'ttPickedOrders.OrderNum' and PickedOrders.Company = Constants.CurrentCompany

Why is my query not validating?