Problem:

Your VOC has:

Select CLIENT_DATA where Status=CLOSE"

RUNREPORT 3 (P)

When there are no matching cases everything is reported.

Issue: How do you stop a VOC?

Solution:

Select CLIENT_DATA where Status=CLOSE"

IF_EMPTY RESET

RUNREPORT 3 (P)

Now before you go running around, tearing AREV apart or searching back issues of REVMEDIA, no IF_EMPTY is not standard AREV.

Here is the code for IF_EMPTY:

Sent=Trim(@SENTENCE)

Command=Field(Sent,' ',2,999)

If Not(@List.Active) then

Perform Command

End Else

@SAVE.SELECT=1

End

In this case my IF_EMPTY fires the RESET TCL command which appears to abort the VOC.

Thanks to all those who offered solutions or other approachs, this was the simplest way that worked.

Bob

Thanks for posting your results.

I had suggested that we use "IF" versions of most TCL VERBS… For us there are advantages that we have added to provide other capabilities but… your RESET (which had not occurred to me) approach could be applicable for much of our work. I currently have the system display each skipped step (caused by the lack of selected records). In some instances, I can create a version of the verb that can cancel all remaining steps (after informing the user of course.

JPryor

View this thread on the forum...