firebird-net-provider

[Firebird-net-provider] 1.1 Alpha 2 - Numeric datatypes bug

[Alessandro P. <pet...@in...>]

Hola Carlos,
I've got some troubles using numeric fields.
If my field is declared as NUMERIC(8,2) everything is ok, but if it is
declared as NUMERIC(10,2) it seems like all values are divided by 1000....
very strange.

Can you reproduce it?

Thank you very much.

Ciao,
Alessandro Petrelli.

Re: [Firebird-net-provider] 1.1 Alpha 2 - Numeric datatypes bug

[Carlos G. A. <car...@te...>]

Hello:

> Can you reproduce it?

I'm testing it but without problems, here is my test case:

I have added to a table two fields like this:

     NUMERIC_08       NUMERIC(8,2),
     NUMERIC_10       NUMERIC(10,2)


Test values are

	NUMERIC_08		NUMERIC_10

	1000			100000	
	2000			200000
	3000			300000
	4000			400000
	5000			500000
	6000			600000
	7000			700000
	8000			800000
	9000			900000


And here is the test code:


FbConnection connection = new FbConnection(connectionString);
connection.Open();

FbTransaction transaction = connection.BeginTransaction();

FbCommand command = new FbCommand();

command.CommandText = "select numeric_08, numeric_10 from test_table_01 
order by int_field";
command.Connection	= connection;
command.Transaction	= transaction;

FbDataReader reader = command.ExecuteReader();

while (reader.Read())
{
	Console.WriteLine("8,2 : {0} || 10,2 : {1}", reader[0], reader[1]);
	Console.WriteLine();
}

connection.Close();




There are anything bad in this example ???





-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] 1.1 Alpha 2 - Numeric datatypes bug

[Alessandro P. <pet...@in...>]

"Carlos Guzman Alvarez" <car...@te...> wrote in message
news:3F1...@te......

<cut>
>
> There are anything bad in this example ???

I'm very sorry.. I forgot to tell you I was inserting values...

If I use the following example with the 1.0 Provider I get the values
correctly stored but if I use the 1.1a2 version (or the CVS version) I get
the values divided by 1000.

Here is my code:

   FbConnection Conn = new FbConnection(connectionString);
   Conn.Open();

   FbTransaction Trans = Conn.BeginTransaction();

   FbCommand Cmd = new FbCommand("INSERT INTO MYTABLE(NUMERIC_08,
NUMERIC_10) VALUES (@NUMERIC_08, @NUMERIC_10)", Conn, Trans);
   Cmd.Parameters.Add("@NUMERIC_08", FbType.Numeric).Value = 100.50M;
   Cmd.Parameters.Add("@NUMERIC_10", FbType.Numeric).Value = 100.50M;
   Cmd.ExecuteNonQuery();

   Trans.Commit(); // rolled back by default?
   Conn.Close();

And the DDL:

CREATE TABLE MYTABLE (
    NUMERIC_08  NUMERIC(8,2),
    NUMERIC_10  NUMERIC(10,2)
);


Thank you.

Ciao,
Alessandro Petrelli.

Re: [Firebird-net-provider] 1.1 Alpha 2 - Numeric datatypes bug

[Carlos G. A. <car...@te...>]

Hello:

> I'm very sorry.. I forgot to tell you I was inserting values...
> 
> If I use the following example with the 1.0 Provider I get the values
> correctly stored but if I use the 1.1a2 version (or the CVS version) I get
> the values divided by 1000.

Fixed in CVS in 1.1 branch, although this is working OK in new 1.5 
sources :D



-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] 1.1 Alpha 2 - Numeric datatypes bug

[Alessandro P. <pet...@in...>]

"Carlos Guzman Alvarez" <car...@te...> wrote in message
news:3F1...@te......
> Hello:
>
> > I'm very sorry.. I forgot to tell you I was inserting values...
> >
> > If I use the following example with the 1.0 Provider I get the values
> > correctly stored but if I use the 1.1a2 version (or the CVS version) I
get
> > the values divided by 1000.
>
> Fixed in CVS in 1.1 branch, although this is working OK in new 1.5
> sources :D
>

Well done.

Thank you very much.

Ciao,
Alessandro Petrelli.