DevForce Community Forum : Parameterized Stored Procedure call in PassthruRdbQuery http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce Classic : Parameterized Stored Procedure call in PassthruRdbQuery Wed, 10 Jun 2026 05:55:04 -700 Sat, 18 Sep 2010 04:47:50 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=2162 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Parameterized Stored Procedure call in PassthruRdbQuery : Hi Kim,The placeholder was exactly... http://www.ideablade.com/forum/forum_posts.asp?TID=2162&PID=8557#8557 Author: toddb
Subject: 2162
Posted: 18-Sep-2010 at 4:47am

Hi Kim,

The placeholder was exactly where I was going wrong...all starting to make a little more sense now. Thank you!

Kind regards,
Todd
]]> Sat, 18 Sep 2010 04:47:50 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2162&PID=8557#8557 Parameterized Stored Procedure call in PassthruRdbQuery : You can use the PassthruRdbQuery... http://www.ideablade.com/forum/forum_posts.asp?TID=2162&PID=8550#8550 Author: kimj
Subject: 2162
Posted: 17-Sep-2010 at 12:23pm

You can use the PassthruRdbQuery in this way, although the parameter placeholder names in the ParameterizedSql need to be correct for the database provider.  If you're using the OleDb provider then "?" is the correct placeholder.  You can obtain the provider-specific name by calling rdbKey.AdoHelper.GetParameterPlaceHolderName(parm).
 
You can instead use a StoredProcRdbQuery for this, which might be a bit simpler.  You can create the query like this:
   Dim query as New StoredProcRdbQuery("security", "GetNextAvailableId", yourdynamicType)
 
and then add the parameters to the query.
]]> Fri, 17 Sep 2010 12:23:45 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2162&PID=8550#8550 Parameterized Stored Procedure call in PassthruRdbQuery : Hi David,I had seen that post... http://www.ideablade.com/forum/forum_posts.asp?TID=2162&PID=8536#8536 Author: toddb
Subject: 2162
Posted: 16-Sep-2010 at 3:40pm

Hi David,

I had seen that post which appears to be the same as the Help documentation. Unfortunately it does not have an example of multiple parameters being passed through to a Stored Procedure which is where I think I am having problems.

Using SQL Server Profiler I can see it make the call to the database but I don't think it is actually passing the parameters. Should I be able to use a PassThruQuery in this way??

Kind regards,
Todd
]]> Thu, 16 Sep 2010 15:40:32 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2162&PID=8536#8536 Parameterized Stored Procedure call in PassthruRdbQuery : See this post:http://www.ideab... http://www.ideablade.com/forum/forum_posts.asp?TID=2162&PID=8535#8535 Author: davidklitzke
Subject: 2162
Posted: 16-Sep-2010 at 2:51pm

See this post:

http://www.ideablade.com/forum/forum_posts.asp?TID=394&title=parameterizedsql-in-passthrurdbquery


]]> Thu, 16 Sep 2010 14:51:04 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2162&PID=8535#8535 Parameterized Stored Procedure call in PassthruRdbQuery : Hi,Is it possible to call a Stored... http://www.ideablade.com/forum/forum_posts.asp?TID=2162&PID=8525#8525 Author: toddb
Subject: 2162
Posted: 16-Sep-2010 at 12:11am

Hi,

Is it possible to call a Stored Procedure with multiple parameters via a PassthruRdbQuery?

A few lines extracted from my code are below:

            Dim Parameters(2) As RdbParameter
            Parameters(0) = New RdbParameter("@ModelName", DbType.AnsiString)
            Parameters(1) = New RdbParameter("@IDField", DbType.AnsiString)
            Parameters(2) = New RdbParameter("@Method", DbType.Byte)

            Parameters(0).Value = pModelName
            Parameters(1).Value = pIdField
            Parameters(2).Value = 1

            Dim sql As New ParameterizedSql("EXEC [Security].[GetNextAvailableId] @ModelName, @IDField, @Method", Parameters)
            Dim query As New PassthruRdbQuery(PS.GetDynamicType("NextAvailableId"), sql)

            Dim el = PM.GetEntities(query)

When it makes the GetEntities call it fails with the following exception:

"Must declare the scalar variable "@ModelName"

Any help would be greatly appreciated.

Thanks,
Todd
]]> Thu, 16 Sep 2010 00:11:33 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2162&PID=8525#8525