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