SELECT (OpenInsight 16-Bit) [Revelation On-Line Wiki]

OpenInsight 16-Bit, Rick Todd, Richard Hunt, Dave Harmacek

Join The Works program to have access to the most current content, and to be able to ask questions and get answers from Revelation staff and the Revelation community

At 01 MAR 2002 10:11:48PM Rick Todd wrote:

Why would this code not report the number of records in a table?

SELECT "CUSTOMER"

REC=@RECCOUNT

CALL MSG(@WINDOW,REC)

I can use the System Editor to display records in the "CUSTOMER" table, but the CALL statement displays nothing.

Thanks

Rick

At 01 MAR 2002 11:36PM Richard Hunt wrote:

It's your select statement. Try this…

DECLARE SUBROUTINE RLIST

SENTENCE=SELECT CUSTOMERS'

RLIST(SENTENCE,5,,,'')

REC=@RECCOUNT

CLEARSELECT

CALL MSG(@WINDOW,REC)

It works just a bit slow as it counts every row in the table.

At 04 MAR 2002 11:28AM Dave Harmacek wrote:

Why not just use the Get.RecCount function?

View this thread on the Works forum...