Subject Re: [IBO] Volume Data Adding
Author Helen Borrie
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:
>for lots of times do
> ib_dsql.parambyname('a').astype := x;
> ib_dsql.parambyname('b').astype := y;
> ib_dsql.parambyname('c').astype := z;
> ib_dsql.execsql;
>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 ยท