Subject Re: [IBO] Stored proc question
Author Helen Borrie
At 02:48 PM 29-05-01 +0200, you wrote:
>Hi all,
> I have a stored procedure that is executed a few times. When it's
>executed the second time I'm having a Invalid DSQLA structure or something
>like that (forgotten to write it down immediatly).
>My program looks like this :
> if not Prepared then
> Prepare;
> Params [0].AsString := Trim (IB_Edit1.Text);
> ExecProc;
>Do I have to do a close and a Unprepare every time it's executed again ?

Yes, unfortunately, with executable stored procedures you do, because of a bug in the API function, that fails to clear a field in that structure after execution.


All for Open and Open for All
InterBase Developer Initiative ยท