Richard joggled a memory, I recall attempting to get Crystal Reports to use the indexes between two tables via datasets. It would not use the indexes other than the initial select. I did find I could use the Microsoft Shape to get the parent child relationship needed through one dataset which improved performance substantially.
With that, how are they using the datasets? Are they letting the power of VFP show with a VFP command or trying to use the datasets like any other dataset? Tracy -----Original Message----- From: Richard Kaye Sent: Tuesday, November 10, 2009 2:48 PM Basic rule of Rushmore: the left side of your expression must exactly match an index for the query to be optimized. Don't know about any limitation to Rushmore in the VFP OLEDB driver. A brief stroll through the help does not mention Rushmore at all but implies that the OLE DB provider has all the features of the ODBC driver along with support for more VFP specific functionality including calling stored procs and DBC events. rk _______________________________________________ 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/000a01ca6240$5759eaa0$060dbf...@com ** 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.
