Kurt Wendt wrote on 2012-09-20: > > So - I'm looking to make an update - to one DBF - that uses multiple IDX > files. To solve a particular problem - I am looking to create a CDX for > that DBF file - but, for only ONE New Index - but, still have the main > system keep using the older IDX files as well. > > > I was initially assuming that this was completely Viable to do - to have > both a CDX attached to a DBF - and ALSO Still use the Older IDX files. > Although - last night - when I was doing initial testing - I ran into a > problem. I haven't finished analyzing the problem yet - but, was > wondering if its due to the CDX vs. IDX and that BOTH can NOT be used on > a DBF at the Same time! > > > Can anyone Confirm or Deny this??? I'm under pressure to solve a HUGE > EDI problem for a client that is causing BIG Chargebacks - and they Just > reported yet Another occurrence of More chargebacks this morning - and > the client is freaking out. And, of course, folks here are putting the > pressure on me to solve the problem PRONTO! > > > Thanks, > -K- >
Kurt, There are things to watch out for listed in the Help file. I've not used IDX and CDX's together. It looks like you may need to create the CDX with a different name preventing it from being auto-opened (INDEX ON ... TAG ... OF newcdx). When it is auto-opened, and the USE command uses the INDEX clause without an ORDER clause, the order is data entry. When you only use the INDEX clause with just IDX, the ORDER defaults to the first IDX file. Tracy Pearson PowerChurch Software _______________________________________________ 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.
