Malcolm, Good spot Malcolm, I forgot about that one and I got bitten with it about 6 months ago when I set up a server and forgot to set the codepage correctly.
Details are on the Wikki: http://fox.wikis.com/wc.dll?Wiki~VFP9RushmoreAndCodepage~VFP Check out CPDBF() and CPCURRENT() Dave Crozier The secret to staying young is to live honestly, eat slowly, and to lie about your age -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Malcolm Greene Sent: 25 October 2006 07:46 To: [email protected] Subject: Re: Slow VFP9 Hi Sytze, I believe your problem is related to code page of your indexes. I can't remember the details (you may want to post on the UT?) but I think you need to make sure that your indexes and your tables have matching code pages - ideally both should use Machine Collation. (Disclaimer: I may be mixing things up with that description, but it may be enough to get you started) While I can't remember the specifics, the good news is that the problem can be easily fixed. I hope my mutterings ring a bell with someone on this list :) Good luck! Malcolm [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 ** 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.
