Well - the problem is - it's a BIG file in the system - and, this file is already used ALL Over The Place within the EDI processing in our system. My plan was to leave the system and all programs alone - and let them work just they way the are with the older IDX files. But, let VFP automatically update this new CDX file - and then Only access the CDX file explicitly in one program. But, my first test - after attaching the CDX - the older programs crashed - since the "Set Index to" command actually Failed - as I reported below - and, of course, its because I added the CDX. So - at this point - since this problem is so urgent - I'm going to instead create a new look-up file, instead of adding the CDX - since its obviously messing things up...
-K- -----Original Message----- From: ProfoxTech [mailto:[email protected]] On Behalf Of Richard Kaye Sent: Thursday, September 20, 2012 10:26 AM To: [email protected] Subject: RE: DBF's, CDX's & IDX's - Oh My... You should be able to explicitly SET ORDER TO a different index file, CDX or IDX, but the default active index file when you USE the table will be the structural CDX (i.e. the one with the same name as the DBF). I'll often do this when I need a temporary index. Another thing you have to keep in mind when you have additional indexes is you must explicitly open them for them to be updated. VFP will only open the structural CDX when the table is USEd. -- rk -----Original Message----- From: ProfoxTech [mailto:[email protected]] On Behalf Of Kurt Wendt Sent: Thursday, September 20, 2012 10:16 AM To: [email protected] Subject: RE: DBF's, CDX's & IDX's - Oh My... Seems I answered my own question. After a real quick test - its obvious that if you have a CDX attached to a DBF - even if you attempt to Set Index to an IDX file - VFP Refuses to let you do it. It won't report an error or crash - it simply as though it ignores that you issued the command. Oh well - on to another solution... -K- [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/289ea162f5642645b5cf64d624c66a140e260...@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.
