Hi Aleksey,

There's no memory leak in your code. You have to comment out ?SYS(1016),SYS(1011) in the FOR to make it.

FOR I=1 TO 40
* ?SYS(1016),SYS(1011)
  y=SQLGETPROP(h,"ConnectString")
 NEXT
...
Visual FoxPro 08.00.0000.2521 for Windows
907820  1055 
922064  1156 

>Hi Sergey,
>
>>Looks like a bug to me but it's SQLGETPROP() that has memory leak. It looses one memory handle ( SYS(1011) ) per each call.
>>
>I don't see a leak from SQLGETPROP, below is the code I use and the output I get. Am I missing something?
>
>

>CLEAR
>SET ALTERNATE TO alternate.txt
>SET ALTERNATE ON
>?VERSION()
>?SYS(1016),SYS(1011)
>h=SQLCONNECT()
>FOR I=1 TO 40
>?SYS(1016),SYS(1011)
>y=SQLGETPROP(h,"ConnectString")
>NEXT
>SQLdisCONNECT(h)
>?SYS(1016),SYS(1011)
>SET ALTERNATE off
>SET ALTERNATE to
>MODIFY COMMAND alternate.txt NOWAIT
>return
>

>
>Here is the output:
>

>Visual FoxPro 08.00.0000.2521 for Windows
>992036 1193
>992176 1196
>992408 1198
>992408 1198
>992408 1198
>992408 1198
>992408 1198
>992408 1198
>992408 1198
>992408 1198
>992408 1198
>992408 1198
>992408 1198
>992408 1198
>992408 1198
>992408 1198
>992408 1198
>992408 1198
>992408 1198
>992408 1198
>992408 1198
>992408 1198
>992408 1198
>992408 1198
>992408 1198
>992408 1198
>992408 1198
>992408 1198
>992408 1198
>992408 1198
>992408 1198
>992408 1198
>992408 1198
>992408 1198
>992408 1198
>992408 1198
>992408 1198
>992408 1198
>992408 1198
>992408 1198
>992408 1198
>992280 1195
>

>
>Thanks,
>Aleksey.