Re: [Firebird-net-provider] SP execute error, when in SP name i'm

[Carlos G. A. <car...@te...>]

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.