Zeoslib Portal

thank your for help
i think that i have solved problem with disconnect and connect to db when user does not have opened any query, table etc.

I have read about commit retain, that zeos dos not do hard commit untill i close connection. And with commit or rollback transaction, stored procedure is locked.

In IBexpert or Flamerobin procedure is executed normaly. But problem is with locks.
I do use autocommit=true but i still have problem. I have tried to commit or rollback but as long as i dont close connection procedure is locked.

I am using Delphi7, zeoslib, firebird 2.0 and stored procedure for getting reports in big commercial app. Problem is that after calling once stored procedure TZQuery nor TZReadOnlyQuery does not release procedure after close. Is there any way to do it?! If i try to change procedure in , exp. IBExper...