Subject RE: [firebird-support] Parameters to SP from VB.NET
Author Tim Gahnström
>> Dim fc As FbCommand = New FbCommand("SP_GET_MOVIES_ALL(?)", con)
>Have you tried
>Dim fc As FbCommand = New FbCommand("SELECT * FROM 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.

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.