Subject TIB_DSQL - conversion error on a value not referenced?
Author ra8009
I have a program that's assigning a simple UPDATE statement to a the
SQL property of a TIB_DSQL instance at runtime. This operation is part
of a while loop and I call ExecSQL after the SQL is set. The SQL looks
like this:

UPDATE MYTABLE SET MYVAR20FLD = MYSTRING1 WHERE MYVAR20FLD = MYSTRING2

At the runtime the statment runs correctly a few times, then it errors
saying that "conversion error from string QW-34-8907".

Here's the problem. At the moment that the query runs the value of
MYSTRING2 is NOT QW-34-8907. The value QW-34-8907 exists in my table,
but is not in any way referenced in the currect SQL statement.

I've unsuccessfully tried:

1) clearing the parameters: DSQL1.Params.ClearBuffers(rsNone);
2) Using IB_DSQL2.ExecuteDML(Statement,nil);

What else could be causing this?