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

[<car...@te...>]

Hello:
> FbCommand myCommand =3D new FbCommand("EXECUTE PROCEDURE=20
> INSERT_RESERVATION", myConnection, myTransaction);
>
> myCommand.Parameters.Add("@COMPANY_NAME", FbDbType.VarChar, 100,=20
> "COMPANY_NAME").Direction =3D ParameterDirection.Input;
>
> myCommand.Parameters.Add("@PASSENGER_NAME", FbDbType.VarChar, 100,=20
> "PASSENGER_NAME").Direction =3D ParameterDirection.Input;
>

As people has told you yet or you put the parameters in tthe command=20
text, or, you can do this:

FbCommand myCommand =3D new FbCommand("INSERT_RESERVATION", myConnection,=
=20
myTransaction);
myCommand.CommandType =3D CommandType.StoredProcedure;
myCommand.Parameters.Add("@COMPANY_NAME", FbDbType.VarChar, 100,=20
"COMPANY_NAME").Direction =3D ParameterDirection.Input;
myCommand.Parameters.Add("@PASSENGER_NAME", FbDbType.VarChar, 100,=20
"PASSENGER_NAME").Direction =3D ParameterDirection.Input;



--=20
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 )