title: Delphi - Clear Param Data for TADOStoredProc
body: <p>for BDE, we can clear the param data like below. </p>
  
  <pre><code> with tstoredproc do
      begin
      .
      .
        for i := 0 to ParamCount - 1 do Params[i].Clear;
      .
      .
  
      end
  </code></pre>
  
  <p>how to do the same for ADO Dataset's? I do not want to create params. i am using TADOStoredProc component and it is having all the params. i Just need to clear data and assign new data.</p>
  
  <pre><code>with TADoStoredProc do
  begin
  .
  .
   for i := 0 to ParamCount - 1 do Parameters[i].Value := null; -- is this right? or can i use below line of code
   Parameters.Refresh
  .
  .
  end;
  </code></pre>