Thanks Sergey.
>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?
>>