Micheal:
I always clean up the cursors in an attempt to use as few resources as
possible. This is is my prg I call after cursors
are created.
*****************
local i, lnTable_count
local array laOpen_tables(1,2)
wait window "Cleaning Up Temporary Tables..." nowait
lnTable_count = 0
lnTable_count = aused(laOpen_tables)
if lnTable_count > 0 then
for i = 1 to alen(laOpen_tables,1))
if left(laOpen_table,3) == "tT_" then
select (laOpen_table(i,2))
use
endif
endfor
endif
wait clear
******************
All of my cursors that I create all begin with tT_ for temp table and after the
underscore some short name to aid in the
selection of the cursor.
Regards,
Jack Skelley
MB Software Solutions wrote:
> 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.
