>When you're done with temp cursors you've created, do you explicitly >close them or do you just leave them
I always explicitly close them, because, as some others have suggested, there's a risk of using the same name for two different temporary cursors. In a situation where I create a lot of cursors (such denormalizing data for a report), I maintain a list of them in an array and close all of them at the end of the run. Ken Dibble www.stic-cil.org _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
