>Hello,
>I have an application that runs continuously, and creates and uses cursors. I always Zap them after I use them, but is that enough? If I create a cursor, use it, zap it, and then 30 seconds later create the same cursor to use again am I using up memory? Should I be destroying the cursor everytime?
ZAP is not necessary. Just closing a cursor will eliminate it, because of the way they are defined. Also, creating the cursor again will eliminate the previous one.
Finally, if you use a form with a private dataenvironment, often you don't even need to close your cursors - they get closed - and therefore destroyed - when you close the form.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)