I just tested with the following code: Select * from MyTable into cursor crsTest NoFilter ReadWrite Index On Field1 Tag Ord1 Index On Field2 Tag Ord2 Additive
and it worked as expected. Possible causes you get the error: #1. You didn't add ReadWrite #2. Your cursor is created with table buffering #3. You didn't add NoFilter and what you see is actually the original table filtered and somehow the new index conflicts with one of existing indexes. On Fri, Mar 5, 2010 at 12:14 AM, Jon Westcot <[email protected]> wrote: > Hi all: > > The subject line kind of says it all. I'm trying to create a temporary > cursor that has two indexes. I'm using the SELECT... INTO CURSOR option to > create said cursor, then issue my two index statements. The first one, > INDEX ON... TAG x works just fine, but the second one, INDEX ON... TAG y > ADDITIVE, fails. > > I _know_ that I've been able to do this in the past, and I just cannot > remember how to do it. Do I need to create the cursor first and then > populate it? Or is there a way to get this type of code to accept two (or > more) indexes that I'm just not remembering? > > Thanks for any help you can send my way! > > Appreciatively, > > Jon > > [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.
