I was looking for a way to speed up PERFORM "SELECT..." statements from
an RBASIC program due to customer complaints about speed when I came
across the REDUCE system subroutine. I was delighted to find that there
was a considerable improvement in system response by replacing the
PERFORM "SELECT ..." with an equivalent call to REDUCE (a 15 seconds
search reduced to 7 seconds is most welcomed). However, I soon received
a call from my customer that if no records could be selected by the
REDUCE call, I was returning the whole list to him.
In my old version, I used codes such as :
PERFORM "SELECT ..."
returned by REDUCE is also set as successful, so I can't use this as a
test for no records selected.
Is there anyone out there with a solution to this? I would dearly love
to use REDUCE to get the speed improvement, but I can't if there is no
way to test for zero records selected.
Thanks in advance,