Francisco, did you carefully read all of my message and the examples I posted? Sorry to ask, but I don't have the impression you did.
What you experience probably is working as designed. At least probably "as designed by Microsoft" (for .net providers). _IF_ you are using the FbParameters collection correctly, declaring the FbParameters["@MyParamName"].Type as "Decimal", _AND_ provide a decimal value to the FbParameters["@MyParamName"].Value, everything will work fine, I am quite sure. Your example does not contain *any* parameter (it simply misses any "@", which is required to introduce a parameter in .net). Please try again. If it does not work, please post a more complete part of your code, and please better use the list "Firebird-net-provider" to not bother the non-net users. I am sure that memberst of that list will be able to help you very quickly! best regards, André > Thanks André; > I've declarated the FbConnection, and FbCommand. > Everything works fine with connection and Command. > If I send a Query like this: > SQLString = "INSERT INTO MyTable(CANT) VALUES(MyAmount)" > considering the Field CANT as String, and the same thing for MyAmount, > FireBird has no problem to save the data. > the problem is, when CANT is Decimal data type, or Numeric, or Float. > Any one? > How to save a decimal data type in Firebird from an app?? > doesn't matter if the programming languaje is other than VB.Net > I need to know how to save a decimal data into firebird like this: 25.80 > thanks > > Francisco José Scheffer > ________________________________ > De: André Knappstein <[email protected]> > Para: Francisco José Scheffer <[email protected]> > Enviado: miércoles, 29 de mayo de 2013 10:35 > Asunto: Re: [firebird-support] Save decimal data type > > > Francisco, > to me this does not look like proper code for .net. > Personally I am using C#, but I know quite some of VB.net. > You need: > - a Command object (of Type FbCommand) > - a Parameter object (of Typ FbParameter) > look at the following links for further guidance to VB.net in this > regard: > http://www.dreamincode.net/forums/topic/165141-sql-parameters-from-vbnet/ > http://idealprogrammer.com/net-languages/code-samples/vbnet-sql-parameters-source-code-insert-statement/ > http://www.java2s.com/Code/VB/Database-ADO.net/PassParameterintoSQLcommand.htm > Have fun! >> thanks Ann; >> Here is some code; >> Declaration >> Dim MyAmount as Double /* Double - 64 bit floating-point number */ >> Dim SQLString as String >> MyAmount = 25.80 >> SQLString = "INSERT INTO MyTable(CANT) VALUES(MyAmount)" >> In Firebird, the field CANT is: (I've tried Numeric, Decimal and FLOAT also) >> With Decimal was 18,4 >> Numeric was 12,2 >> When Firebird save the data, it does as 2580, not 25.80; >> Is it perhaps a problem on my Windows regional settings? >> thanks for help!! >> Francisco José Scheffer >> ________________________________ >> De: Ann Harrison <[email protected]> >> Para: [email protected] >> Enviado: martes, 28 de mayo de 2013 17:36 >> Asunto: Re: [firebird-support] Save decimal data type >> On Tue, May 28, 2013 at 10:26 AM, franchessko <[email protected]> wrote: >>> Hi, I'm a new firebird user. I joined here to ask for help. >>> I develop in DotNet Technologies, and I have this problem: >>> >>> >>> And the problem is: >>> ------------------- >>> When I send a Query with a decimal data type like '25.80' -without quotes- >>> the data is saved in firebird like this 2580,0000 >>> (the database field was created as Decimal 18,4) >>> >> Without seeing the actual queries you used, I'm guessing about why you see >> what you see, but I can tell you what Firebird is doing. When you store >> 25.80 in a column that's defined as decimal 18,4, Firebird stores the >> value as in integer, which in this case would be 258000 (two hundred fifty >> eight thousand). The scale is part of the field definition. Firebird uses >> the scale when doing comparisons, so 258000 scale 4 is more than 2570000 >> scale 5 and less than 260 scale 1. All that is fine, internally. >> However, the SQL numeric and decimal types are based on data types used in >> COBOL. Those data types are not generally supported in more modern >> languages. When you retrieve a decimal or numeric value with a non-zero >> scale, you should probably ask for it as a floating point number or a >> string. You'll get better information from the Firebird .NET driver list >> on exactly how to push decimal and numeric values through that interface. >>> I tried sending the same number, but with the comma '25,80' but firebird >>> says: "Dynamic SQL Error. SQL Error code = -804. Count of read-write >>> columns does not equal count of values" >>> >> Firebird does not use the locale to choose the separator between the >> integral and decimal portions of a number, so it's reading 25,80 as two >> values 25 and 80. >> Good luck, >> Ann >> [Non-text portions of this message have been removed] >> >> ------------------------------------ >> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ >> Visit http://www.firebirdsql.org and click the Resources item >> on the main (top) menu. Try Knowledgebase and FAQ links ! >> Also search the knowledgebases at http://www.ibphoenix.com >> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ >> Yahoo! Groups Links > mit freundlichen Grüßen, > André Knappstein > EDV und Controlling > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > beta Eigenheim- und Grundstücksverwertungsgesellschaft mbH > Hafenweg 4 > 59192 Bergkamen-Rünthe > Telefon: +49 2389 9240 140 > Telefax: +49 2389 9240 150 > e-mail: [email protected] > Amtsgericht Hamm Nr. B 420 > Geschäftsführer: Achim Krähling, Dirk Salewski und Matthias Steinhaus > USt-IDNr.: DE 125215402 > > [Non-text portions of this message have been removed] > ------------------------------------ > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > Visit http://www.firebirdsql.org and click the Resources item > on the main (top) menu. Try Knowledgebase and FAQ links ! > Also search the knowledgebases at http://www.ibphoenix.com > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > Yahoo! Groups Links mit freundlichen Grüßen, André Knappstein EDV und Controlling ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ beta Eigenheim- und Grundstücksverwertungsgesellschaft mbH Hafenweg 4 59192 Bergkamen-Rünthe Telefon: +49 2389 9240 140 Telefax: +49 2389 9240 150 e-mail: [email protected] Amtsgericht Hamm Nr. B 420 Geschäftsführer: Achim Krähling, Dirk Salewski und Matthias Steinhaus USt-IDNr.: DE 125215402
