From: Oleg U. <ol...@ya...> - 2004-03-11 10:44:07
|
Can i use this method for recieve table schema of select stored procedure? I try do this thing, but i catch exception: ---------------- An unhandled exception of type 'FirebirdSql.Data.Firebird.FbException' occurred in system.data.dll Additional information: Dynamic SQL Error SQL error code = -204 Table unknown TEST_SELECT At line 1, column 15 ----------------- My code sample: using (FbConnection connection = new FbConnection(ConnectionString)) { connection.Open(); FbTransaction transaction = connection.BeginTransaction(); FbCommand selectCommand = new FbCommand("TEST_SELECT", connection, transaction); selectCommand.CommandType = CommandType.StoredProcedure; FbDataAdapter adapter = new FbDataAdapter(selectCommand); DataTable table = new DataTable(); adapter.FillSchema(table, SchemaType.Source); transaction.Commit(); } |