Re: [Firebird-net-provider] DeriveParameters question

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

Hello:

> When I use the function "FbCommandBuilder.DeriveParameters(command)" to get
> the parameters of a Stored Procedure, I expected to have the input
> parameters before and after the output parameters, but the parameters are
> mixed. For instance for a stored procedure with several input parameters and
> with one output parameter, as first I find the first input parameter
> followed by the output parameter and then the other input paramaters.
> 
> Is this the correct behaviour?

If you are using version 1.5 it can be :) i'm using this to retrieve 
parameter information:

DataTable spSchema = 
command.Connection.GetDbSchemaTable(FbDbSchemaType.Procedure_Parameters,
				new object[] {command.CommandText});

This execs a select against rdb$procedure_parameter table ordered by:

	rdb$procedure_name
	rdb$parameter_number	


I'm going to make a test using this in the ORDER BY clausule :

	rdb$procedure_name
	rdb$parameter_type
	rdb$parameter_number	





-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain