| Subject | Re: [IBO] Avoid closing and opening with parameters |
|---|---|
| Author | Helen Borrie |
| Post date | 2006-10-21T22:01:01Z |
At 04:43 AM 22/10/2006, you wrote:
execute a DML statement, you shouldn't be calling open, close,
refresh, etc., but Execute. Before each execution of a prepared
statement, call Clear on any params you want to clear; simply assign
new values to any that you want to replace.
Parameters in SELECT statements are row selectors, i.e. changing a
parameter value requires a Refresh in order to replace the old set
with the new one, but yo don't have to (and shouldn't) reprepare the
query. If you are using the iboquery to return a dataset for a
parameterised statement then assign the parameters and call Refresh.
That is a Close and Open under the hood.
Helen
>When using an IBOQuery, how can I reset a parameter without having toWhat do you mean by "reset"? If you are using the iboquery to
>close and reopen the query?
execute a DML statement, you shouldn't be calling open, close,
refresh, etc., but Execute. Before each execution of a prepared
statement, call Clear on any params you want to clear; simply assign
new values to any that you want to replace.
Parameters in SELECT statements are row selectors, i.e. changing a
parameter value requires a Refresh in order to replace the old set
with the new one, but yo don't have to (and shouldn't) reprepare the
query. If you are using the iboquery to return a dataset for a
parameterised statement then assign the parameters and call Refresh.
That is a Close and Open under the hood.
Helen