At 05:18 PM 11-06-01 +0100, you wrote:

>Thanks Geoff,
>
>Just got one problemette..
>
>i've used a kind of combination of the ideas below. I have put the
>insert statement into the sql strings property of the IB_DSQL component
>with a parameter for the actual data value (i.e. insert into tablename
>values (:a, :b, :c)) then in my app I have prepared the dsql, set up the
>parameter values and excecuted:
>
>ib_dsql.prepare;
>ib_dsql.beginbusy(true);
>for lots of times do
>begin
> ib_dsql.parambyname('a').astype := x;
> ib_dsql.parambyname('b').astype := y;
> ib_dsql.parambyname('c').astype := z;
> ib_dsql.execsql;
>end;
>ib_dsql.endbusy;
>ib_dsql.unprepare
>
>This compiles ok but when I run it I get an error saying "invalid
>transaction handle (expecting an explicit transaction start)
>
>I've obviously missed something here. I've tried puting a transaction
>component on the DM and puting a starttransaction just before the
>prepare but this didn't do the trick.

Is the dsql connected to the transaction?

-- H

PS Please could you trim your messages? Thanx.

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________