Error Finding Exit Script?

[John Chamberlain]

Can someone point me to some examples of exit scripts? I need a script that will (1) find any empty records and delete them, and (2) will locate records that may have required fields missingl, then exit the script on the proper record and layout, so that corrections may be made.

[OlgerDiekstra]

How about the below?

 

go to layout ["layout that has fields to correct entries"]

if [isEmpty ( $$Looping) 

   go to record/request/page [first]

endif

set variable $$Looping="yes"

loop

   set variable $Correct="yes"

   // check some fields 

   set variable if [field1 ≠ HasValidValue; "no"; $Correct)

   set variable if [field2 ≠ HasValidValue; "no"; $Correct)

   if [$Correct="no"

      exit script

   endif

   go to record/request/page [next; exit after last]

   end loop

set variable $$Looping=""

 

This would allow you to stop the loop, correct the error, then push the button that triggers the script again and it will resume. You could add some additional safety measures in to make sure records arent skipped while correcting errors.

[Kris M]

John.

Your better off learning the field level validation options and preventing undesireable records from being committed in the first place