>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???
Just a SWAG - maybe the second parameter needs to be passed by reference; in case of the literal string Fox may be doing that for you (i.e. pass the reference to the string). Just try
lnRetVal = SQLEXEC(lnHandle, @lcSQL, "tCursor")
it might work, well, if my theory holds (not that I tried it...).