General information
Category:
Coding, syntax & commands
Title:
SQLEXEC not working with variable as parameter
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???
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only