The USE IN closes a cursor and releases anything releted to it. No additional actions required.

USE (d_purchase) ALIAS i_purchase IN 0
SELECT * FROM i_purchase WHERE dInv>=startdate AND dInv<=enddate INTO CURSOR c_purchase
USE IN i_purchase
...
USE IN c_purchase

>I used a lot of Select ... from ... into cursor ... in my app.
>
>

>USE (d_purchase) ALIAS i_purchase IN 0
>SELECT * FROM i_purchase WHERE dInv>=startdate AND dInv<=enddate INTO CURSOR c_purchase
>USE IN i_purchase
>
>USE (d_sales) ALIAS i_sales IN 0
>SELECT * FROM i_sales WHERE dInv>=startdate AND dInv<=enddate INTO CURSOR c_sales
>USE IN i_sales
>

>
>and so on...
>to capture the transactions from other app (difference dbc) to my app.
>
>I wonder if I will end up with out of memory problem.
>
>how can I release the cursor?
>