At 08:08 AM 1/03/2009, you wrote: >Content-type: multipart/alternative; > boundary="Boundary_(ID_oVBjsEmn9+tV6lC4Elg+UQ)" >Content-language: en > >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.
This error code happens during execution of some query you have inside the body of your stored procedure. If you had the correct firebird.msg available, you would have seen a message like At line @1, column @2 (where @1 and @2 would be the line numbers and positions in the SP code where the exception occurred. As you don't provide the body of your SP, it would only be a guess as to what provoked the error; but check whether you're actually referring to the BARCODE variable somewhere in your insert statement, where you have forgotten to give it the ':' prefix. (Hmmm, perhaps you've overlooked it for *all* of the variables in the Insert statement, :BARCODE being just the first.) It's beyond guessing why your firebird.msg isn't being found. It *should* be in the firebird server's rootdir. If it's really there then one has to suspect that you have a misdirected FIREBIRD variable on the server. Helen ------------------------------------------------------------------------------ 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
