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 MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 _______________________________________________ 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.
