AnsweredAssumed Answered

Server Script Error 101 - No Records Found - Workaround Solution??

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

Hi All - previously got help from bigtom on getting this working but different query now!

 

So I have this script that runs on the server every couple of minutes that searches for records and updates if it fits the if statement. Now only problem is when there is no records to update; the script receives the 101 error.

 

Can anyone advise a fix for the below as I only want notified if there is a problem, not no records present.

I've tried the below but no sucess:

 

Set Error Capture [On]

Go To Layout ["CurrentDevicesAndStock"(CurrentDevices)]

Show All Records

Enter Find Mode [Pause]

Set Field [CurrentDevices::Live; 0]

Set Field [CurrentStock::Live;1]

Perform Find []

If [Get(FoundCount) = 0]

   Exit Script[]

Else

   Go To Record / Request / Page [First]

   Loop

        Set Field [CurrentDevices::Live;0]

        Go To Record [Next; Exit after last]

     End Loop

End if

Outcomes