Gavin,

Try SYS(1104). See INFO: Undocumented Function SYS(1104) mskb #269284.


>
>I'm working on a Windows service written in VP6.0 that has a number of SQL statements that return a large amount of data into cursors. When the cursors are created they take up a large amount of memory ( in some cases up to 800mb ) which isn't a problem, but when they are closed the memory is not being freed up.
>
>I've tried RELEASE ALL, CLEAR ALL, CLEAR MEMORY, CLOSE DATABASES ALL, but the memory usage remains high. The only way to free the memory seems to be to restart the service.
>
>The service is running on a W2K SP3 Terminal Server with 2GB of RAM, 20GB harddrive and an Intel 2.80GHZ Xeon processor. The data being accessed comes from VFP DBFs.
>
>Does anyone have any ideas why memory would not be released after closing a Cursor?
>