Hello together,
this is the first real problem I have with .net provider for more than
2 years; great work! Thanx!
But this one is really scaring me.
I get an FBException "arithmetic exception, numeric overflow or string
truncation", suddenly.
And I only get it in .net using provider 2.0.1, the same query runs
fine in IBExpert, for example, on the very same server and the same
database.
As far as I can tell, that routine is still running fine in the
deployed version of my application...
Here is what is causing the exception:
Cmd_PosMax = new FbCommand();
Cmd_PosMax.Connection = Program.DBConn101;
Cmd_PosMax.CommandText =
"Select " +
" max(D3017003.P3017_017Z) " +
"from " +
" D3017003 " +
"where " +
" D3017003.P3017_001Z = @IDEBA ";
Cmd_PosMax.Parameters.Add("@IDEBA", FbDbType.Char, 5);
Cmd_PosMax.Parameters["@IDEBA"].Value = IDEBA;
sPoxMax = Cmd_PosMax.ExecuteScalar();
I don't have the slightest clue what is going on or wrong.
And my experience is not good enough to know where to start looking.
The parameter "IDEBA" at the time has a valid content (for example
"27315", but the exception gets thrown on _all_ possible content, so
it's not just the matter of one ID.
Thanks in advance,
André
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
beta Eigenheim- und Grundstücksverwertungsgesellschaft mbH
Hafenweg 4
59192 Bergkamen-Rünthe
Telefon: +49 2389 9240 0
Telefax: +49 2389 9240 150
e-mail: [email protected]
Amtsgericht Hamm Nr. B 420 || USt-IDNr.: DE 125215402
Geschäftsführer: Achim Krähling, Dirk Salewski, Matthias Steinhaus
------------------------------------------------------------------------------
Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are
powering Web 2.0 with engaging, cross-platform capabilities. Quickly and
easily build your RIAs with Flex Builder, the Eclipse(TM)based development
software that enables intelligent coding and step-through debugging.
Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
