🚀 go-pugleaf

I'm trying to use an stored procedure to execute this Access 2000 query with
parameters.

SELECT Param.CustNo, Param.Type, Param.No, Param.Description, Param.HelpText
FROM Param
WHERE (((Param.CustNo)=[:CustNo]) AND ((Param.Type)=[:Type]));

The code is this:

CamposParamStProc->Close();
CamposParamStProc->Parameters->ParamByName("Type")->Value=Type;
// this Parameter is defined as a String, Size 1
CamposParamStProc->Parameters->ParamByName("CustNo")->Value=CustomerNo;
// this parameter is designed as a Long Integer
CamposParamStProc->Open();

Although the Type and CustomerNo do change, the values returned by the
Stored Procedure are always the same.

Why don't data refresh? What should I do to force a refresh? Do I forget
something?

(The query works perfectly on Access: is too simple to fail!)

Thanks in advance,
      Jorge Bustos.

P.S. While in the IDE the only way I have succeded to get the desired
records was this:
1) Set Active to false
2) Change the parameter values
3) Clear the Connection property
4) Set the Connection property to its previous value
5) Set Active to true

If I don't take steps 3 and 4 the data don't refresh... Why? I'm getting mad
about this!