Getting result count from RList() (OpenInsight 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 08 APR 1998 02:59:02PM Bryan Feddish wrote:

OpenInsight Specific

(Sorry, I should have included this in the last one…)

How do I simulate the @recount variable in AREV to get the number of rows returned from the RList() and Activate_Save_Select() functions?

Thanks,

Bryan

At 08 APR 1998 03:53PM Dave wrote:

Bryan,
    I think that the system variable @reccount holds that information. There is also the function Get.RecCount which will return
the number of records in a table it is documented in the online help. If you are saving the List to syslists then you could use Get.RecCount.

DaveRevelation

At 09 APR 1998 02:43PM Cameron Revelation wrote:

Bryan,

How do I simulate the @recount variable in AREV to get the number of rows returned from the RList() and Activate_Save_Select() functions?

AFAIK if you use the R/List "active select list" target, it sets @reccount.

Activate_Save_Select definitely sets @reccount, although previous to the 3.6 release it was sometimes off by one (see the 3.6 readme).

Cameron Purdy

[email protected]

View this thread on the forum...