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? 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/!&[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.
