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:skopalik@...
http://www.elektlabs.cz <http://www.elektlabs.cz/>




-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Francisco Jos�
Scheffer
Sent: Wednesday, May 29, 2013 5:17 PM
To: firebird-support@yahoogroups.com
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 <Knappstein@...
<mailto:Knappstein%40beta-eigenheim.de> >
Para: Francisco Jos� Scheffer <firebird-support@yahoogroups.com
<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]