Subject Reset params if a TIB_StoredProc
Author kokok_kokok
I am using a TIB_StoredProc for several purposes. My problem is that
I need to assign all parameters, although some of them can be NULL.

For example:

sp.StoredProcName="STORED_NUMBER_1";
sp.ParamByName("DATE").Value=myDate;
sp.ParamByName("TIME").Value=myTime;;
sp.ExecProc();


sp.StoredProcName="STORED_NUMBER_2"; //it has DATE and TIME
parameters
sp.ParamByName("DATE").Value=myDate;
sp.ExecProc();


In the second case, if I do not assign "time" pameter but the former
value is kept.So, STORED_NUMBER_2 stored procedure "reads"
TIME=myTime.

I have solve it doing: sp.ParamByName("TIME").Clear();

But I am looking for a function to "reset" all parameters.