Subject | RE: [firebird-support] Parameters to SP from VB.NET |
---|---|
Author | Tim Gahnström |
Post date | 2005-04-19T15:48:20Z |
>> Dim fc As FbCommand = New FbCommand("SP_GET_MOVIES_ALL(?)", con)Thanks a lot to both you and Martijn. It seems like you both said the same thing and that it solved it. I wouldn't have figured it out in a million years on my own.
>Have you tried
>Dim fc As FbCommand = New FbCommand("SELECT * FROM SP_GET_MOVIES_ALL(?)", >con)
I wonder how I managed to get it to work occasionally.
With the new setup it works well both with
fc.CommandType = CommandType.StoredProcedure
fc.CommandType = CommandType.Text
Which one would be the appropriate one?
Thanks again
Tim --Praying that the "The Firebird Book" will be in my mailbox anyday.