Thanks Luiz!

It works for me with Unprepare; Prepare;
It just took me some time to find out...

Anyhow, I appreciate your comments.

Regards,

Luiz schrieb:

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