|Subject||RE: [firebird-support] Parameters to SP from VB.NET|
>> 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?
Tim --Praying that the "The Firebird Book" will be in my mailbox anyday.