Hi Kevin.
>For VFP apps that access SQL Server, are there any documents on the Wiki (or anywhere else on this forum) that covers the pros and cons of SPT vs Remote Views ( vs Stored Procs)?
Check this link:
http://fox.wikis.com/wc.dll?Wiki~MoreOnRemoteViews~VFP>nQueryResult = SQLEXEC(nMyConn, 'SELECT ' + [&cFieldList] + ' FROM ' + [&cFileList] + ' WHERE ' + [&cWhere] + ' GROUP BY ' + [&cGroupBy],"ResultSet")
The & aren't needed in this case, since unlike SQL SELECT, the SQLEXEC() expects to be passed a string.
Doug