Wednesday, August 31, 2005

WideOrbit Mass Order Separation Change

This script will allow you to change the order separation for an entire station for orders entered on or after the date specified. We used this to reset our order separation to an hour. After running this script, you will have to displace all of the spots from the date forward and let placer replace the spots.

Update WO_OrdersSet WO_ORDERS.ORDER_SEPARATION=3600000FROM WO_ORDERS INNER JOIN WO_STATIONS ON WO_ORDERS.STATION_ID = WO_STATIONS.STATION_IDWHERE (WO_ORDERS.CREATE_DATE >= CONVERT(DATETIME, '2005-07-15 00:00:00', 102)) AND (WO_STATIONS.STATION_CALL_LETTERS = 'ORD-PACE')

The script is permanently listed on my Resources->WideOrbit page. Use this script at your own risk. None of these WO scripts are scantioned by WO. In fact, they will probably tell you not to use them. So if you decide to use this, it's your neck.

No comments: