>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?
Does SQLEXEC() not do what you want?
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up