Subject | Reset params if a TIB_StoredProc |
---|---|
Author | kokok_kokok |
Post date | 2004-05-06T13:12:05Z |
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.
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.