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.

Regards,
Helen

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________