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???