Thanks Helen

I just thought there might have been a
Query.FunnyWordedMethodToClearAllParams :)

Rob Martin
Software Engineer

phone +64 03 377 0495
fax +64 03 377 0496
web www.chreos.com

Wild Software Ltd



Helen Borrie wrote:

> 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
>
>
>
>
> ___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
> ___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info papers,
> keyword-searchable FAQ, community code contributions and more !
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>