Re: [Firebird-net-provider] A problem with Firebird SP returning values

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

Hello:

Try with this:

**********************
procedure Page_Load;
var
 myConnection : FBConnection;
 myCommand : FBCommand;
 transaction: FBTransaction;
 parameterHits: FBParameter;
begin
 myConnection :=
FbConnection.Create(ConfigurationSettings.AppSettings.Get('ConnectionString'
));
 myConnection.Open;
 transaction:=myConnection.BeginTransaction;

 myCommand := FbCommand.Create('EXECUTE PROCEDURE HITSGETTOTAL', myConnection, transaction);		<---
 myCommand.CommandType := CommandType.StoredProcedure;

 parameterHits := FbParameter.Create('HITS', FbType.Integer);
 parameterHits.Direction := ParameterDirection.Output;
 myCommand.Parameters.Add(parameterHits);

 myCommand.ExecuteNonQuery;
 lblHits.Text:='Total: ' + parameterHits.Value.ToString;

 transaction.Commit;
 myConnection.Close;
 myCommand.Free;
end;
*************************


Best regards
Carlos Guzma'n A'lvarez
Vigo-Spain


P.S: Please send emails in plain text format.