> -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf > Of Paul Hill > Sent: 12 September 2008 11:59 > To: ProFox Email List > Subject: Re: SQL > not optimised - Rushmore failing > > On Fri, Sep 12, 2008 at 11:41 AM, NickC <[EMAIL PROTECTED]> wrote: > > Getting back to the original problem I think I have found the cause, not > > necessarily the solution but at least getting closer. > > > > > > Further testing suggests that the cause is SET ANSI ON!!! > > > > In ADO SET ANSI is ON by default, I don't know if there is any way that > can > > be changed. > > > > Have been testing this in Fox and have discovered that with SET ANSI OFF > > (the Foxpro default) things are fine, well almost. However, once ANSI > is > > set ON Rushmore seems to stop working when the table gets beyond a > certain > > size. Looking at memory usage it seems as if Rushmore fails completely > and > > Fox retrieves the entire table, even though SYS(3054) still claims that > > Rushore is working. > > > > Has anyone else had a problem with SET ANSI ON and large tables? > > What is the codepage of your tables? Use CPDBF() to check. > They should be 1252 (Western European). > > -- > Paul >
Yep code pages are all 1252 Nick _______________________________________________ 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/!&!AAAAAAAAAAAYAAAAAAAAAOO2KhH5xw1Oq9ETMzh8UaqijQAAEAAAAAUlh3/[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.
