Jose C Gomez
T: 904.469.1524 mobile
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>, <jose@...> 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.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.
Which generates this error when it's validated.for each PickedOrders no-lock where PickedOrders.OrderNum = ttPickedOrders.OrderNum and PickedOrders.Company = Constants.CurrentCompany
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.ttPickedOrders OrderNum must be a quoted constant or an unabbreviated unambiguous buffer/field reference for buffers known to query . (7328)
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>