I always give my cursors names starting with cur. I have a library routine which I call at the end of each module which uses AUSED() to close all tables starting with cur. I tend to close them when I have finished with them to free up memory and also because I just don't like having them hang around - what isn't there can't bite you <g>.
John Weller 01380 723235 07976 393631 > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of MB Software Solutions > Sent: 14 May 2007 03:43 > To: [EMAIL PROTECTED] > Subject: Cleaning up temp cursors > > > When you're done with temp cursors you've created, do you explicitly > close them or do you just leave them (whereby they'll be implicitly > closed later at some time during a CLOSE TABLES ALL, CLEAR ALL, or > similar command)? I would think it'd be better to explicitly close > them, but wondered about the consensus here. If a cursor took up a huge > amount of space (i.e., large record size with high record count), then I > could see closing it explicitly, but most of my temp cursors are really > small in size and as such wouldn't be hogging up much resources. > _______________________________________________ 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.
