Is there a fast way to clear all the params for a query? I'm currently doing things like

  if ipForename > 0 then findContact.ParamByName('Forename').AsString := ImportGrid.Cells[ipForename, rCntr] else findContact.ParamByName('Forename').Clear;

because a number of the parameters may not exist. Its in a data import routine so I have to make allowances for some data being supplied an other not.

Roy Lambert

Roy,

<< Is there a fast way to clear all the params for a query? I'm currently
doing things like >>

Unfortunately, the only way to do it is to loop through the Params property
and call the Clear method for each parameter.

--
Tim Young
Elevate Software
www.elevatesoft.com