Mervyn Bick <email@example.com>
||Thu, 7 Feb 2019 22:29:36 +0200
On 2019-02-07 10:08 PM, Ken R. wrote:
> I'm working on a older program that has the following line:
> COPY RECNO() TO TEMP
> in a loop through about 10,000 records. By the end of that loop the PlusRun memory requirement has grown to over 10 times its memory requirements and machine performance slows to a crawl. I have narrowed the problem down to that line. So I'd like to replace that line <COPY RECNO() TO TEMP> >with something simple and straightforward. Any quick advice would be much appreciated. Thanks!!
> Ken R.
It's a LONG time since I used XDML but that syntax looks wrong. It
certainly doesn't work in dBASE 12.3.1. It gives the error "Unallowed
phrase/keyword in command: recno() to temp"
If you want to copy the entire table open in the workarea to TEMP then
COPY TO TEMP
If you want to copy selected records then the syntax would be something like
COPY TO TEMP FOR RECNO() > 5 AND RECNO() <10