Variable for capturing TCL SUM (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 11 OCT 2000 09:11:43AM Rod Morris wrote:

AREV Specific

Is there a variable that can be accessed in RBASIC to use the result in: PERFORM "SUM CUSTOMER BALANCE" or do I have to write my own loop to get the sum?

Thanks in advance

Rod

At 11 OCT 2000 12:28PM Don Miller - C3 Inc. wrote:

Well .. sorry. Gotta roll your own on that one.

Don Miller

C3 Inc.

At 12 OCT 2000 09:17AM [url=http://www.sprezzatura.com]The Sprezzatura Group[/url] wrote:

Older versions of ARev used to place the result into @RECCOUNT. On newer versions you must set @SAVE.SELECT to 1 for the value to be saved. Remember to set @SAVE.SELECT back to 0 to avoid unpredictable actions.

The Sprezzatura Group

World Leaders in all things RevSoft

At 12 OCT 2000 01:15PM Don Miller - C3 Inc. wrote:

Sprezz ..

Ah, c'mon guys. @RECCOUNT is the number of records selected . SUM AR_FILE BALANCE is different (assuming that BALANCE is a money field). You can do a select to filter the table (hopefully a resolved filter), before you sum the field but @RECCOUNT won't hold the money total.

Sorry 'bout that ..

Don Miller

C3 Inc.

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

Don

We did try this before we posted to check. Hence the "Worlds Leaders" tag .

The Sprezzatura Group

World Leaders in all things RevSoft

At 12 OCT 2000 03:36PM Don Miller - C3 Inc. wrote:

Sprezz..

Mea Culpa, oh chief hoo-ha-do-da

Do you know at what version this stopped working??

Don

At 12 OCT 2000 03:58PM Don Miller - C3 Inc wrote:

Sprezz..

I tried the following in AREV 1.16, 2.03, 2.12, 3.12:

R/basic program @REC.COUNT=0 PERFORM 'SELECT AREC WITH DATE FROM "01/01/2000" TO TODAY' * at this point @REC.COUNT=1325 [email protected] @REC.COUNT=0 PERFORM 'SUM AREC BALANCE' * the screen shows $127,433.25 DEBUG * @REC.COUNT=0 Soooooooooo - what am I missing??? Don Miller C3 Inc. </QUOTE> —- === At 12 OCT 2000 05:06PM The Sprezzatura Group wrote: === <QUOTE>@save.select=1 and (s The Sprezzatura Group World Leaders in all things RevSoft </QUOTE> —- === At 12 OCT 2000 10:19PM Rod Morris wrote: === <QUOTE>Thanks for all the attention. The @SAVE.SELECT worked like a charm! All you pros do a real service for us "know just enough to get in trouble guys" Thanks for taking the time to respond to all the questions!!!!! Rod </QUOTE> View this thread on the forum...