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 _______________________________________________ Post Messages to: ProFox@leafe.com 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.
