Subject | Parametized TIB_Query (for update) problem |
---|---|
Author | cicero@alkasoft.com.br |
Post date | 2001-01-09T19:26:14Z |
Hi IBO users!
I have a parametized UPDATE query and every time that I use the query
I have to prepare it. I want to prepare it one only time and change
the parameters for new calls. The problem is that the parameters not
change when I assign new values for them. The only way to change the
parameters values is clear the SQL, assing the same statement and
prepare the query again. Why IBObjects retain the old parameter values
when the parametized update query is call again?. How I can change
the parameter values? I try use "Parameter.Clear"
and "Parameters.ClearBuffers" but doesn´t work.
When I use a parametized query for SELECT all works fine.
Help!
Thanks
Cicero
I have a parametized UPDATE query and every time that I use the query
I have to prepare it. I want to prepare it one only time and change
the parameters for new calls. The problem is that the parameters not
change when I assign new values for them. The only way to change the
parameters values is clear the SQL, assing the same statement and
prepare the query again. Why IBObjects retain the old parameter values
when the parametized update query is call again?. How I can change
the parameter values? I try use "Parameter.Clear"
and "Parameters.ClearBuffers" but doesn´t work.
When I use a parametized query for SELECT all works fine.
Help!
Thanks
Cicero