Hello:
> 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"
RETURNS (
INT_FIELD INTEGER,
VARCHAR_FIELD VARCHAR(100),
DECIMAL_FIELD DECIMAL(15,2))
AS
begin
SELECT INT_FIELD, VARCHAR_FIELD, DECIMAL_FIELD FROM TEST_TABLE_01
WHERE INT_FIELD = 2 INTO :INT_FIELD, :VARCHAR_FIELD, :DECIMAL_FIELD;
suspend;
end
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;
FbCommandBuilder.DeriveParameters(command);
FbDataReader reader = command.ExecuteReader();
reader.Close();
--
Un saludo
Carlos Guzmán Álvarez
Vigo-España
"Todos somos muy ignorantes. Lo que ocurre es que no todos ignoramos las
mismas cosas."
Albert Einstein.
|
