> Simple example:
> Create empty SP with any low case name (f.e. mystoredproc).
> and try execute it...
I have made the test, the only way i have found to create an sp with a
name like SelectData for example is makeing the name to be queted, if
not the sp name will be uppercased always, at least in my tests, an example:
CREATE PROCEDURE "SelectData"
SELECT INT_FIELD, VARCHAR_FIELD, DECIMAL_FIELD FROM TEST_TABLE_01
WHERE INT_FIELD = 2 INTO :INT_FIELD, :VARCHAR_FIELD, :DECIMAL_FIELD;
This sp needs to be executed as ( but quoted names will not wok with
DeriveParameters at this moment i will try to make anything for allow
this to be made ):
FbCommand command = new FbCommand("\"SelectData\"", connection);
command.CommandType = CommandType.StoredProcedure;
FbDataReader reader = command.ExecuteReader();
Carlos Guzmán Álvarez
"Todos somos muy ignorantes. Lo que ocurre es que no todos ignoramos las