At 11:37 AM 29/06/2006, you wrote:

>Hi
>
>I have an insert query with many parameters. I want to clear (NULL) the
>values of all parameters in between uses. What is the best way to do
>this. I am using a TIBOQuery component.

...
var
ii integer;
..
for ii := 0 to MyQuery.ParamCount-1 do
MyQuery.Params[ii].Clear;

Helen