I would use a tib_cursor to avoid problems.

Luiz.

----- Original Message -----
From: "Boris Schlüszler" <boris@...>
Newsgroups: egroups.ibobjects
To: <IBObjects@yahoogroups.com>
Sent: Sunday, June 02, 2002 11:00 AM
Subject: Re: [IBO] TIB_StoredProc-results error


> 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/
>
>
>
___________________________________________________________________________
> 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/
>
>
>