>Right now, I'm testing from the VFP command window so the code looks like (after variables are assigned a value)
>
>msql1 = "Execute InsertTestResults "
>m.param1 = "?m.sbank, ?m.scn, ?m.tcn"
>ms1 = sqlexec(mconn, msql1 + m.param1)
>
>
>mconn = SQLStringConnect(SQLCStr) where
>SQLCSTR = "Driver = SQL Server;Server = DEVSERVER;uid = 'Herbie';Trusted_Connection = Yes;APP=Microsoft Visual FoxPro; WSID = PC1; Database = DLI_Testing"
>
>yes, the connection is good.
>
>InsertTestResults is basically, after parameters are defined
>
>Insert into TestResult (Subbank, SCN, TCN) values ('E0' + @Subbank, @SCN, @TCN)
What does ms1 return? The procedure has only 3 parameters in that exact order (bank, scn, tcn), right?
If it's not broken, fix it until it is.
My Blog