Using
Firebird 2.1.1.17910
FirebirdSql.Data.FirebirdClient.dll 2.0.1.0
FlameRobin 0.9.01748
VisualStudio 2008
I have a stored procedure written in FlameRobin that runs as designed when
executed from FlameRobin.
However, when that same sproc is called from my winforms client, using the same
parameter values I put in FlameRobin, I get this error:
Dynamic SQL Error
SQL error code = -206
Column unknown
BARCODE
No message for error code 336397208 found.
BARCODE is an input parameter, it is not the name of any column in the target
tables. Here is the
sproc declaration, the way I call it from the winforms client is below:
CREATE PROCEDURE InsUpdTaxStampChange (
BARCODE VARCHAR(20)
, STCKNO VARCHAR(15)
, QTY integer
, FRLOCID CHAR(6)
, FRLOCSEQ integer
, FRTAXCODE VARCHAR(4)
, FRAISLE CHAR(4)
, FRSLOT CHAR(4)
, FRLVL CHAR(2)
, FRBIN CHAR(2)
, TOLOCID CHAR(6)
, TOLOCSEQ integer
, TOTAXCODE VARCHAR(4)
, TOAISLE CHAR(4)
, TOSLOT CHAR(4)
, TOLVL CHAR(2)
, TOBIN CHAR(2)
, TRANSLOGTYPE CHAR(1)
, TRANSLOGDESC VARCHAR(25)
)
AS
here is how its called from my C# app:
using (FbConnection conn = new FbConnection(connstr))
{
conn.Open();
FbTransaction tran = conn.BeginTransaction();
FbCommand cmd = new FbCommand("InsUpdTaxStampChange", conn, tran);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("BARCODE", FbDbType.VarChar, 20);
cmd.Parameters.Add("STCKNO", FbDbType.VarChar, 15);
cmd.Parameters.Add("QTY", FbDbType.Integer);
cmd.Parameters.Add("FRLOCID", FbDbType.Char, 6);
cmd.Parameters.Add("FRLOCSEQ", FbDbType.Integer);
cmd.Parameters.Add("FRTAXCODE", FbDbType.VarChar, 4);
cmd.Parameters.Add("FRAISLE", FbDbType.Char, 4);
cmd.Parameters.Add("FRSLOT", FbDbType.Char, 4);
cmd.Parameters.Add("FRLVL", FbDbType.Char, 2);
cmd.Parameters.Add("FRBIN", FbDbType.Char, 2);
cmd.Parameters.Add("TOLOCID", FbDbType.Char, 6);
cmd.Parameters.Add("TOLOCSEQ", FbDbType.Integer);
cmd.Parameters.Add("TOTAXCODE", FbDbType.VarChar, 4);
cmd.Parameters.Add("TOAISLE", FbDbType.Char, 4);
cmd.Parameters.Add("TOSLOT", FbDbType.Char, 4);
cmd.Parameters.Add("TOLVL", FbDbType.Char, 2);
cmd.Parameters.Add("TOBIN", FbDbType.Char, 2);
cmd.Parameters.Add("TRANSLOGTYPE", FbDbType.Char, 1);
cmd.Parameters.Add("TRANSLOGDESC", FbDbType.VarChar, 25);
foreach(ItemTransfer item in this)
{
try
{
cmd.Parameters["BARCODE"].Value = item.Barcode;
cmd.Parameters["STCKNO"].Value = item.StckNo;
cmd.Parameters["QTY"].Value = item.Qty;
cmd.Parameters["FRLOCID"].Value = item.FromCo;
cmd.Parameters["FRLOCSEQ"].Value = item.FromWhse;
cmd.Parameters["FRTAXCODE"].Value = item.FromTax;
cmd.Parameters["FRAISLE"].Value = "0000";
cmd.Parameters["FRSLOT"].Value = "0000";
cmd.Parameters["FRLVL"].Value = "00";
cmd.Parameters["FRBIN"].Value = "00";
cmd.Parameters["TOLOCID"].Value = item.ToCo;
cmd.Parameters["TOLOCSEQ"].Value = item.ToWhse;
cmd.Parameters["TOTAXCODE"].Value = item.ToTax;
cmd.Parameters["TOAISLE"].Value = "0000";
cmd.Parameters["TOSLOT"].Value = "0000";
cmd.Parameters["TOLVL"].Value = "00";
cmd.Parameters["TOBIN"].Value = "00";
cmd.Parameters["TRANSLOGTYPE"].Value = "T";
cmd.Parameters["TRANSLOGDESC"].Value = "TaxStampAuto";
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
tran.Rollback();
conn.Close();
LogMsg lm = new LogMsg("ErrorLog.txt", ex, _verbose);
return false;
}
}
tran.Commit();
conn.Close();
}
return true;
I would really appreciate any help I could get on this one. It has me stumped.
depperson
------------------------------------------------------------------------------
Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA
-OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise
-Strategies to boost innovation and cut costs with open source participation
-Receive a $600 discount off the registration fee with the source code: SFAD
http://p.sf.net/sfu/XcvMzF8H
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
