Jeff,
Check the original SQL-Server database for the exact spelling/case of "Person".
Have you tried writing the SQLEXEC code as a single line and running this with a macro?
cSQL = [SQLEXEC(lnHandle, 'Select * from Patient', "tCursor")]
? &cSQL
I do this regularly with local data.
HTH
Barbara
>Having trouble with SQL Passthru using VFP 6 and MS SQL 7. I suspend my app where it's failing and manually make a new connection with the following command:
>
>lnhandle=sqlconnect(DSN, UserId, PassWord) - I verify the connection is good.
>
>I define a string variable as lcSQL='Select * from Patient'
>
>This command does NOT work:
>lnRetVal = SQLEXEC(lnHandle, lcSQL, "tCursor")
>
>But this one DOES:
>lnRetVal = SQLEXEC(lnHandle, 'Select * from Patient', "tCursor")
>
>What gives???