Hello:

I sent some zips through, not sure if they made it. Here is a class and the ddl for the database. I'm still completely stumped by this.

Try to define the parameters in the same ordes as in the sp:

           param = new FbParameter("@FK_CurrencyID", FbDbType.Integer);
           param.Value = currencyID;
           com.Parameters.Add(param);

           param = new FbParameter("@Name", FbDbType.VarChar);
           param.Value = name;
           com.Parameters.Add(param);

           param = new FbParameter("@Code", FbDbType.VarChar);
           param.Value = code;
           com.Parameters.Add(param);

           param = new FbParameter("@IsPercentage", FbDbType.SmallInt);
           param.Value = isPercentage;
           com.Parameters.Add(param);

           param = new FbParameter("@ID", FbDbType.Integer);
           param.Direction = ParameterDirection.Output;
           com.Parameters.Add(param);



--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain


-------------------------------------------------------
SF.Net email is sponsored by:
Tame your development challenges with Apache's Geronimo App Server. Download
it for free - -and be entered to win a 42" plasma tv or your very own
Sony(tm)PSP.  Click here to play: http://sourceforge.net/geronimo.php
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Reply via email to