Subject | TIB_DSQL - conversion error on a value not referenced? |
---|---|
Author | ra8009 |
Post date | 2004-08-25T04:26:15Z |
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?
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?