When I type (at the system monitor)

RUN RLIST "COUNT NHSALES",1

I get the count of records, but when I type

RUN RLIST "COUNT NHSALES WITH YEAR EQ '99'",1

I get the entire list of those @ids which contain '99' in the field {YEAR}, but the actual count does not appear. This happens regardless of what field I use.

Is the problem that I am not allowed to use boolean logic with "count" at the system monitor?

David

There is an OpenList keyword "CountRow," that works with "WITH" as in:

RUN RLIST "CountRows NHSALES WITH . . . etc"

Could it be possible that "Count" isnt recognized with "WITH" and so defaults to "Select" as in:

RUN RLIST "Select NHSALES WITH . . . etc" 

(?)

Ah, makes sense to me. Yes, probably "Count" doesn't understand boolean, the rlist defaults to "select" - more likely because the rlist string parser makes that presumption.

Thanks!

David

There is an OpenList keyword "CountRow,"

There is? Where? In the Pro version?

- Oystein -

Oystein-

I looked, there is in fact the word "CountRows" in the OpenList documentation.

It is listed as a keyword. Also, under "WITH" in Appendix A there even is an example of its use as follows:

CountRows CUSTOMERS With Company "INC."

However, when I type (at the system monitor)

RUN RLIST "CountRows NHSALES with @ID NE ''",1

I get in reply:

"CountRows is an invalid statement type."

Just for the heck of it, I tried:

RUN RLIST "CountRows NHSALES",1

I get in reply:

"CountRows is an invalid statement type."

Take it with a grain of salt - this is the same OpenList documentation which makes reference to controlling printer output through PDISK…

Also, the only help available for "F1"ing "count" is "Counting rows", which yields Get.RecCount function, a total count of all rows in a table, nothing more.

Possibly COUNT doesn't count sub-sets defined by boolean anymore, as just previously suggested by Rev Tech Support. Anyway, it doesn't for me as of yet.

David Singer

View this thread on the Works forum...