Struggling on a simple task I've done a couple times before but just not sorting this one....
So I am setting up a Server Script to run every couple of minutes (done this fine).
I need to basically perform a search on two seperate fields, CurrentDevices::Live = 0 & CurrentStock::Live = 1.
Then any results that will appear the record will have the field updated on CurrentStock::Live to be 0.
Whatever I am doing in my script isn't working so if you could have a look that would be great.
Set Error Capture [On]
Go To Layout ["CurrentDeviceAndStock" (CurrentDev)]
Perform Find [Restore] (Find records: CurrentDevice::Live = 0 and CurrentStock::Live = 1)
If [CurrentDevice::Live = 0]
Set Field [CurrentStock::Live; 1]
Go To Record/Request/Page [Next;Exit after last]