>>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?
ms1 comes back as -1 and I have no new record.
Correct, 3 parameters in that order
"You don't manage people. You manage things - people you lead" Adm. Grace Hopper
Pflugerville, between a Rock and a Weird Place