>> Would using SQL pass through be the best way to communicate with the SQL Server DB?<<
Depends. My testing shows the difference between Remote Views, SQL Passthrough, and CursorAdapters is not anything a customer would recognize if you are using VFP 9 (not true if you are using VFP 5). If you have a super complex query you likely will want to look at SQL Passthrough. Remote Views and Cursor Adapters have tools and builders to simplify coding and getting done faster in my experience. 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/00d001cb9af5$6fbd19c0$4f374d...@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.

