>Is it possible to join data from a local cursor with a table on a SQL server using the sqlexec() function. If so what would the syntax be?
Kris,
You can do this but it must be done in two steps. First run teh SQLEXEC to get the SQL SErver data into a VFP cursor, then do a SELECT ... to join the cursor from SQL Server to the local cursor. For example, assuming an SQL server table name SQLData and a VFP cursor named MYCsr you could;
SQLEXEC(lnConnection,"SELECT * FROM SQLData",MySQLData)
SELECT * FROM MySQLData JOIN MyCsr ON ...