Rafael, >> I am beginning to use VFP9 as a front end and SQL server as a backend. I wonder if any of you can help with examples of code to use ADO with VFP.<<
During my remote data session (presented at Southwest Fox 2009 and German Devcon 2009) I tested the performance of each of the VFP data access techniques and technologies. For the most part remote views, SQL Passthrough, and CursorAdapters using ODBC were about on equal footing performance wise. These tests were done from my desktop to a MySQL database on a server somewhere in Arizona. The tests were run over and over and while each of the technologies took their share of wins, the differences were not all that significant. One thing was for sure though, ADO access was normally between 25 and 100 percent slower than the native technologies. Please note that the performance will depend on several factors though including but not limited to the backend server, the server itself, the wires in between, and the way the queries are programmed. My recommendation is to balance the performance with the ease of use and maintainability, and how the access fits the existing applications if appropriate. Try and test to find the balance. One of the easiest ways to learn how to use ADO and CursorAdapters though is through the VFP 9 (or Sedna) Data Explorer. Create an ADO connection to the data. Drill down to a table, and drag it to a PRG. It will create the code to open a cursor in VFP that you can use all the native XBase commands to manipulate the data, and a simple TABLEUPDATE() to post it back to the backend. It is simply magic. Rick White Light Computing, Inc. www.whitelightcomputing.com www.swfox.net www.rickschummer.com _______________________________________________ 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/000801cb0764$a61b1d70$f25158...@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.
