> I've got a sqlda error when I try to do this
>
> - create a TIB_DSQL with params in select clause; prepare it once
> - go through a loop; change params and execute TIB_DSQL to get a single
> value from a table
>
> This pseudo code was working until nov. 2000. Then Jason changed something
> behind the scene to avoid a known Interbas bug.
>
> Then my pseudo code was running only once; running second time in loop
> caused a sqlda error.
>
> I solved this problem by using TIB_Cursor instead of TIB_DSQL and this

error

> disappears to me.

And now I am sure it works much faster than it did before. Before it was
automatically repreparing the statement each time and now it doesn't have to
do that anymore.

Just be sure if it is an execute procedure you are using that you have a
SUSPEND in its body.

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