Re: [Firebird-net-provider] Executing Procedure Error Help Please!

[Eduardo B. <edu...@gm...>]

You can do in this way too...

FbCommand myCommand =3D new FbCommand("EXECUTE PROCEDURE
INSERT_RESERVATION(?,?)", myConnection, myTransaction);


On 4/18/06, Carlos Guzm=E1n =C1lvarez <car...@te...> wrote:
> Hello:
> > FbCommand myCommand =3D new FbCommand("EXECUTE PROCEDURE
> > INSERT_RESERVATION", myConnection, myTransaction);
> >
> > myCommand.Parameters.Add("@COMPANY_NAME", FbDbType.VarChar, 100,
> > "COMPANY_NAME").Direction =3D ParameterDirection.Input;
> >
> > myCommand.Parameters.Add("@PASSENGER_NAME", FbDbType.VarChar, 100,
> > "PASSENGER_NAME").Direction =3D ParameterDirection.Input;
> >
>
> As people has told you yet or you put the parameters in tthe command
> text, or, you can do this:
>
> FbCommand myCommand =3D new FbCommand("INSERT_RESERVATION", myConnection,
> myTransaction);
> myCommand.CommandType =3D CommandType.StoredProcedure;
> myCommand.Parameters.Add("@COMPANY_NAME", FbDbType.VarChar, 100,
> "COMPANY_NAME").Direction =3D ParameterDirection.Input;
> myCommand.Parameters.Add("@PASSENGER_NAME", FbDbType.VarChar, 100,
> "PASSENGER_NAME").Direction =3D ParameterDirection.Input;
>
>
>
> --
> Carlos Guzm=E1n =C1lvarez
> Vigo-Spain
>
> http://carlosga.blogspot.com/
>
> "When you don't code, you tend to become one of those architects who thin=
ks everything is possible" ( Anders Hejlsberg )
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by xPML, a groundbreaking scripting langua=
ge
> that extends applications into web and mobile media. Attend the live webc=
ast
> and join the prime developer group breaking into this new coding territor=
y!
> http://sel.as-us.falkag.net/sel?cmdlnk&kid=110944&bid$1720&dat=121642
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>


--
----------------------------------------------------------
"I throw myself into the sea
Release the wave, let it wash over me
To face the fear I once believed
The tears of the dragon, for you and for me"

Bruce Dickinson - Tears of the Dragon

=A7=80NT=80NC=80=D0 - MSN - sir...@ho...
edu...@gm...
----------------------------------------------------------