AnsweredAssumed Answered

Perform Find Not Returning Records

Question asked by craig157 on Nov 8, 2017
Latest reply on Nov 8, 2017 by beverly

Hi All,

 

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]

End if.

Outcomes