At 03:15 PM 02-06-02 +0200, you wrote:

>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!

It would suggest that you don't have the output parameters of your SP
correctly defined...somehow, your application is asking for results that
don't exist...


regards,
Helen Borrie (TeamIBO Support)

** Please don't email your support questions privately **
Ask on the list and everyone benefits
Don't forget the IB Objects online FAQ - link from any page at
www.ibobjects.com