|
Hi all
Below is part of some code that has been working for several
years from 6.1, 6.5++ and I think earlier versions of 7.1.
But with the latest build the program locks up or I should
stalls on the second INSERT command.
I can do this with a date range of 1 year and it runs in
about 5 minutes in 6.5++ but trying the same thing in
7.176 it takes over 10 min and never finishes. When I
do Ctrl Alt Del, it says RBase is nonresponsive.
I even tried with whileopt off, no luck.
What would causse this???
thanks
Marc
WHILE vxdate BETWEEN .vsdate AND .vedate THEN
-- set var vsdate = (.vsdate + 1) -- select max(aptdate) into vsdate from aptdate INSERT INTO aptdate (aptdate,ampm) VALUES (.vxdate,'M') SET VAR vxdate = (.vxdate + 1) ENDWHILE
DELETE DUPLICATES FROM aptdate INSERT +
INTO aptbook (aptdate,apttime,ampm) SELECT t1.aptdate,t2.apttime,t2.ampm + FROM aptdate t1, apttime t2 WHERE aptdate BETWEEN .vsdate AND .vedate + ORDER BY aptdate,apttime CLS
LABEL addmend RETURN
|
