If you don't let VFP name the cdx it won't open at all unless you code for it ie give it a different name from the table. Just look at the syntax for index on ... and you'll find a way so as not to make the cdx automatic. BTW, if this works, you'll have to code the re-indexing and maintenance by hand, too. Sounds like maintaining all that idx stuff is hand coded somewhere.
On Thu, Sep 20, 2012 at 11:04 AM, Michael Madigan <[email protected]>wrote: > Years ago I briefly tried doing the same thing with an old system and it > was a nightmare. > > If I remember correctly, someone had a program that would parse through > the foxpro programs and convert all IDXs to CDXs and then create the > correct tags. I'm not sure if someone wrote this internally or whether it > was a program that I found on leafe.com or somewhere on the Internet. > > > > > > ________________________________ > From: Richard Kaye <[email protected]> > To: "[email protected]" <[email protected]> > Sent: Thursday, September 20, 2012 10:50 AM > Subject: RE: DBF's, CDX's & IDX's - Oh My... > > I was just speaking to the ability to use multiple index files at the same > time. > > This is probably why the original dev didn't want to go back and refactor > all that code. You've got change all those set index to commands to set > order to, make sure all your tags are in the cdx and so on. > > -- > rk > > -----Original Message----- > From: ProfoxTech [mailto:[email protected]] On Behalf Of > Kurt Wendt > Sent: Thursday, September 20, 2012 10:36 AM > To: [email protected] > Subject: RE: DBF's, CDX's & IDX's - Oh My... > > 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- > > [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/cafuu78dkbcn_vlsmxrnkqbj0egjcf6fkarigw-gtj6gpwxz...@mail.gmail.com ** 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.
