RoboTask forum

Yes, I understand the approach. The example was very helpful.
Thank you for the help and for such a fine product.

I want to scan all rows by the condition OrdNum_10 like '5%' to detect any changes.
The query select OrdNum_10 from OrderMaster where OrderMaster.OrdNum_10 like '5%' will return approx. 1000 rows.

The Work Order Table contains a field named OrdNum_10 where it lists the Order Number, an 8 digit numeric field. The first digit of the OrdNum_10 field indicates the type of order it is. For example, order numbers beginning with 2 are purchase orders, numbers beginning with 7 are customer orders and...

We currently use RoboTask to perform a series of updates to various Pervasive SQL database tables and use File Monitor, monitoring the Order Master Table, as the Trigger. The problem is that the Order Master Table is accessed frequently by the ERP System, launching the RoboTasks even though the chan...