Since this code is VERY central to many apps, about a dozen of my own, I
know that it works. If it didn't I'd have hundreds of requests. I need to
see a simple sample app from you isolating the issue you are dealing with. I
have a feeling that you will either see what it is you are doing before you
even finish it or I will be able to see what you are doing and tell you.

HTH,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: <cicero@...>
To: <IBObjects@egroups.com>
Sent: Tuesday, January 09, 2001 12:26 PM
Subject: [IBO] Parametized TIB_Query (for update) problem


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