I do not know what happens behind the scene when setting a SP to active. But
I think a SP's adequate verb should be *execute*.

If you drop a IB_Monitor component on your form you will have tons of
informations about what's going on while talking with the DB driver.

If this all does not help: Nobody can help if you do not post here a copy of
the IBO outputs (ISC Errors or/and Monitor).

Heri

> Hi
> When I do the following i get a invalid tranaction handle error.
> What am I doing wrong. I have tried various different combinations of the
> code but no success
>
> SPDiary: TIBOStoredProc;
>
> SPDiary.Prepare;
> SPDiary.ParamByName('IN_DATE').AsDate:=CurrentDiaryDate;
>
> SPDiary.ParamByName('IN_USER').AsString:=DBR.IB_Connection1.LoginUsername;
> SPDiary.Active:=True;
>
> I have also tried Params[0].AsDate but it also does not work.
> I have moved prepare around but it does not have a effect.
>
> I have also deleted the params properties values and created a new

component

> to
> see if that would have a effect.
>
> It is an ISC error. It could mean that I am giving IBO the wrong data
> causing it to
> send the wrong data to the server causing the server to raise this

problem.

>
> I cant find anything in the messages for this year so far relating to this
> problem. I'l search further.
>
> Groete
> Gerhardus
>
>
>
>

___________________________________________________________________________

> IB Objects - direct, complete, custom connectivity to Firebird or

InterBase

> without the need for BDE, ODBC or any other layer.
>

___________________________________________________________________________

> http://www.ibobjects.com - your IBO community resource for Tech Info

papers,

> keyword-searchable FAQ, community code contributions and more !
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>