Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Does this make sense?
Message
From
31/01/2013 17:03:26
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2008
Application:
Desktop
Miscellaneous
Thread ID:
01564885
Message ID:
01564899
Views:
27
>>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform