IN-LINE formulas in VOC records? (AREV Specific) [Revelation On-Line Wiki]

Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community

At 21 JUL 2000 09:14:19AM Mike O'Neal wrote:

AREV Specific

Hello everyone:

If I have a stored VOC record such as

TCL

SELECT table WITH criteria

LIST table

…is there anyway to evaluate whether any records were actually SELECTed before processing the LIST statement? Otherwise all records in the table are output.

TIA,

Mike O.

At 21 JUL 2000 09:33AM Don Miller - C3 Inc. wrote:

Mike..

The easiest way to do this is to catch the sentence and @RECCOUNT

in a routine of your own. Let's call it GLIST for drill:

SUBROUTINE GLIST(SENT)

IF LEN(SENT) THEN
SWAP "GLIST " WITH "LIST" IN SENT
IF @RECCOUNT THEN
   PERFORM SENT
END ELSE
YOU MIGHT WANT TO ASK IF THEY WANT THE WHOLE FILE
END
RETURN

Now your VOC item:

TCL

SELECT table WITH criteria

GLIST table

Is this what you're after?

Don Miller

C3 Inc.

At 21 JUL 2000 01:57PM [url=http://www.sprezzatura.com" onMouseOver=window.status=Click here to visit our web site?';return(true)]The Sprezzatura Group[/url] wrote:

A small point - you might want to use @List.Active in case you ever create latent selects.

The Sprezzatura Group

World Leaders in all things RevSoft

At 21 JUL 2000 02:46PM Mike O'neal wrote:

Thanks much, works great!

Mike O.

View this thread on the forum...