Re: [Firebird-net-provider] Problem with rdb$ tables - possible bug in rc1

[<car...@te...>]

Hello:

> With a Provider 1.1 build: 1.0.1241.28320 the results are ok:

Fixed in CVS, the problem was in a change i have done for try to adjust 
the string readed to the number of real chars in the field character 
set, but this is not valid in the case of System Tables that are 
supposed to be UNICODE_FSS but they report a bad number of bytes (1 per 
character instead of 3 per character).

> btw. How to use restrictions in FbConnection.GetDbSchemaTable?

They works in very similar way to the OleDB provider ones, an example:

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

// Retrieve the list of SYSTEM TABLES
// Restrictions allowed:
//	TABLE_NAME
//	TABLE_TYPE
//	SYSTEM TABLE
DataTable schema = connection.GetDbSchemaTable(
	FbDbSchemaType.Tables,
	new object[] {null, null, 1});

foreach (DataRow row in schema.Rows)
{
	foreach (DataColumn column in schema.Columns)
	{
		Console.Write("{0} \t", row[column.ColumnName]);
	}
	Console.WriteLine("");
}

connection.Close();




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain