OK Mike - I just KNOW you must be bustin' my Chops with that one comment! So - YES - I most Definitely have used CDX's before. Just never on a Cursor.
I created the Indexes exactly like you showed below - and I am excited to see it worked. So - I will move forwards with this method. And - yes - that's what I like about Cursors - that they clean up after themselves (like Potty trained kids!)... :-) Thanks again for all your help! -K- -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of MB Software Solutions, LLC Sent: Wednesday, March 24, 2010 5:52 PM To: [email protected] Subject: Re: Large # Rec's, Cursors & UR Opinion... Kurt Wendt wrote: > So - Mike - sorry if this sounds like a clueless question (but, I'm also > under a crunch to finish this program update) - but, I've never heard of > an Index specific to a Cursor. Although, I suspect you do NOT Mean ORDER > BY when creating a Cursor using SELECT. After doing some quick searching > in the VFP online Help - I see the UNIQUE option within the CREATE > CURSOR - SQL Command. Is THIS the Index that you are referring to? CREATE CURSOR crap (foo c(10), bar i) INDEX ON foo TAG foo INDEX ON bar TAG bar SET ORDER TO foo These may create temp files on disk, but they'll automatically be managed so you don't have to worry about associating the proper IDX to them. They're treated like a CDX. (You've used CDX before, right?) > Sorry to admit I haven't really worked with doing Indexed Cursors. But, > it sure seems that it MUST be the route I follow for this problem of > mine. No problem. It's just like DBFs except that VFP automatically manages/handles all file stuff and cleans up after itself. Easier, imo. -- Mike Babcock, MCP _______________________________________________ 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/289ea162f5642645b5cf64d624c66a14071a1...@us-ny-mail-002.waitex.net ** 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.
