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

Click here to load this message in the networking platform