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