>How can I execute Sql Scripts in VFP? Is there an API or something ??
>
Silvio,
From this thread it appears that you have access to the SQL Server Enterprise Manager. If so, the easiest way to do this would be through SQL-DMO. This is a COM object that allows you to do just about anything (including re-write) the Enterprise Manager can do. For example
oSQL = CREATEOBJECT('SQLDMO.SQLServer')
oSQL.Connect(< server name >, < user name >, < password >)
oDatabase = oSQL.DataBases(< Database name >)
lccmnd = FILETOSTR(< SQL Script file >)
oDatabase.ExecuteImmediate(lccmnd)
Additionally there are ExecuteWithResults and ExecuteWithResultsAndMessages (two of them)methods.
George
Ubi caritas et amor, deus ibi est