Hi!

Found a hint in your online-FAQ!
Bug in IB, "Unprepare" must be used.
So, before any call to a SP I do this:

Unprepare; Prepare; ...

Is that correct?

Regards,

Boris Schlüszler schrieb:

>
> Hi!
>
> I'm using a TIB_StoredProc to manipulate some data.
> ExecProc works fine, and the maniplulation is done.
> But when I try to read the result field I get this error:
>
> "SQLDA missing or incorrect version or incorrect number/type of
> variables"
>
> This error arises whenever the table, the SP is working on, is changed
> by another SP.
> So I suspect it to be a transaction problem.
> In both TIB_StoredProcs "StoredProcHasDML" is set to True,
> AutoDefineParams is False.
>
> "Wrong version" means old version number of interbase versioning model,
> I guess?
>
> However, I don't know how avoid this error.
> "Commit" doesn't help. "Refresh" doesn't help...
>
> Any suggestions?
>
> with AnlKtoSP do begin
> ParamByName('KONTO').AsString:=AnlKtonrEd.Text;
> ParamByName('NAME').AsString:=AnlKtonameEd.Text;
> ExecProc; // up to here everything's fine
>
> EdKtoNameResult.Text:=FieldByName('RESNAME').AsString; // error!
>
> end;
>
>
> ___________________________________________________________________________
> 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/