Subject RES: [IBO] Clearing parameter values
Author Luiz

Hi

 

From IBO Help:

 

{: BDE/VCL compatibility method. It does the same as Execute.

If you are using input parameters, it is very important to be aware that IBO

will preserve parameter values.  You need to clear the values out explicitly,

even when unpreparing and preparing again.

The easiest ways to clear them out are by:

calling the Clear method of the input parameters;  or

Calling the Params.ClearBuffers( rsUnmodified ) method of the Params object.

}

 

Luiz

 

De: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]
Enviada em: sexta-feira, 30 de maio de 2014 16:38
Para: IBObjects@yahoogroups.com
Assunto: [IBO] Clearing parameter values

 

 

Hi All

Sorry if this question seems to be dumb...

What is the best method to clear IB_DSQL parameters values?
If I set IB_DSQL.Params[0].AsString := 'xxx', then unprepare and prepare
statement, Params[0] is still 'xxx'.
Any other way then iterate Params and clear one by one?

TIA
Marcin