SQL Pass-Through (SPT), will do this. Here's a simple example:
myHandle = SQLCONNECT("yourDSN","yourUSERID","yourPASSWORD")
=SQLEXEC(myHandle,"INSERT yourTable VALUES ('a','b','c')")
=SQLDISCONNECT(myHandle)
All the string parameters can of course be variables that you construct elsewhere.
HTH
>Is there a way to build a SQL statement (Update or Insert) on the client and pass the entire statement to be executed on SQL Server?
>
>I am using VFP 6.0 to frontend SQL Server 7.0. I want to build a generic update or insert string based on the current record set and pass the string to SQL Server for processing.
>
>Is there a stored procedure I can pass the SQL String to and have it processed?
"It is an important and popular fact that things are not always what they seem. For instance, on the planet Earth, man had always assumed that he was more intelligent than dolphins because he had achieved so much -- the wheel, New York, wars and so on -- whilst all the dolphins had ever done was muck about in the water having a good time. But conversely, the dolphins had always believed that they were far more intelligent than man -- for precisely the same reasons." - Douglas Adams
