Subject | RES: [IBO] Clearing parameter values |
---|---|
Author | Luiz |
Post date | 2014-05-30T20:36:29Z |
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