I have just ran across a strange memory issue with 3.0b. Each time you run the following code, several megs of memory get chewed up and are not released until I exit VFP. Each time you run it, more memory is gobbled up.


CREATE DATABASE Testmain
CREATE TABLE Customer (Name C(40))
CREATE VIEW Customer_View AS SELECT Customer.Name FROM Customer

FOR nLoop = 1 TO 1000
USE Customer_View IN 0 NODATA
= REQUERY("Customer_View")
USE IN Customer_View
ENDFOR


If you run this several times (or set the FOR loop to a few thousand) you will run out of "virtual" memory etc. I have tested this on NT 4.0 and Win 3.1 on 32MB machines with similar results.

I couldn't find any previous threads on this. Anyone with an idea on what's going on or how to prevent it?

BTW, no problems running it under VFP 5.0.

Thanks!

-Doug-