Hi, if is it posible, use DOUBLE PRECISION data type instead NUMERIC one. But be carefoully with comparasion on exact value. Like CREATE TABLE test( num1 DOUBLE PRECISION ); Slavek Ing. Slavomir Skopalik Executive Head Elekt Labs s.r.o. Collection and evaluation of data from machines and laboratories by means of system MASA (http://www.elektlabs.cz/m2demo) ----------------------------------------------------------------- Address: Elekt Labs s.r.o. Chaloupky 158 783 72 Velky Tynec Czech Republic --------------------------------------------------------------- Mobile: +420 724 207 851 icq:199 118 333 skype:skopaliks e-mail:[email protected] http://www.elektlabs.cz <http://www.elektlabs.cz/>
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Francisco José Scheffer Sent: Wednesday, May 29, 2013 5:17 PM To: [email protected] Subject: Re: [firebird-support] Save decimal data type 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] <mailto:Knappstein%40beta-eigenheim.de> > Para: Francisco José Scheffer <[email protected] <mailto:firebird-support%40yahoogroups.com> > Enviado: miércoles, 29 de mayo de 2013 10:35 Asunto: Re: [firebird-support] Save decimal data type [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 <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
