Here's a different approach: I'm using _only_ private datasessions, and because of this I don't have to worry about temporary cursors. On the other hand, the cursors are always prefixed with "crs" (I'm avoiding "cur" as prefix because it has some nasty meaning in Romanian), but keeping the notation convention would allow me to close those cursor almost anytime, programatically, like you do.
----- Original Message ----- From: "John Weller" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, May 14, 2007 11:21 AM Subject: RE: Cleaning up temp cursors >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. >> > > > [excessive quoting removed by server] _______________________________________________ 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.
