Re: [Firebird-net-provider] NET Provider (stored procedures)

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

Hello:

> FbParameterCollection param = new FbParameterCollection();

Huummm .... be careful with this that will be no more possible with 1.5
version of the Firebird .NET Data provider ( as in SqlClient provider ).


> param.Add( new FbParameter("@userloginname", 
> FirebirdSql.Data.Firebird.FbType.VarChar, "Lee"));
> 
> param.Add( new FbParameter("@userloginpass", 
> FirebirdSql.Data.Firebird.FbType.VarChar, "Pass"));
> 
> int result = sql.ExecuteNonQuery(connectionString, 
> CommandType.StoredProcedure, "LOGINUSER", param);
> 
> *What am I doing wrong?  Thank you!*


I can't test it now but try adding the output parameters too:

param.Add( new FbParameter("@userloginname", FbType.VarChar, "Lee"));
param.Add( new FbParameter("@userloginpass", FbType.VarChar, "Pass"));

param.Add( new FbParameter("@userloginid", FbType.Integer, 0));
param.Add( new FbParameter("@userprivilegeid", FbType.SmallInt, 0));


param[@userloginid].Direction = ParameterDirection.Output;
param[@userprivilegeid].Direction = ParameterDirection.Output;





-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain