At 08:41 AM 22/02/2005 +0000, you wrote:

>In this time I get strange error.
>When I set SQL in this procedure, and call ExecSQL (params:
>ID,TS_ID,WHEN), and set SQL to another SQL (params: ID), the IBOQuery
>SQL parser is not drop previous ID param, it is use the previous value.
>
>Previous: insert into ts (ID,TS_ID,WHEN) values (:ID,:TS_ID,:WHEN)
>ID is string.
>Actual: delete from ts where TS_ID=:id.
>ID is integer.
>
>But previous value is string, and now it have integer value.
>The prepare raise exception (string->integer).
>
>I try everything. I clear SQL. I clear params. I clear everything, but
>the problem is living.
>
>What I can do to prevent this ?
>
>(Ok I can do an dummy RDB$DATABASE reading, but I don't want to do it.
>I think that is clear the params).

What database server and version are you using? Which version of IBO?

Helen