Also, FB 2.5.0 has problems with this. If you use this version upgrade to 2.5.1 or above.
De: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Enviada em: segunda-feira, 18 de agosto de 2014 16:47 Para: firebird-support@yahoogroups.com Assunto: Re: [firebird-support] object is in use Hello Carlos. Thanks. I am using IBExpert to run an 'CREATE OR ALTER PROCEDURE MY_PROCEDURE....." That´s why I am not understending what can avoid to execute this. This PROCEDURE just returns a value from a table. I should be able to drop and insert a PROCEDURE at anytime into the DB. Should not I? Em 18/08/2014 16:40, 'Carlos H. Cantu' lis...@warmboot.com.br [firebird-support] escreveu: When you start a transaction you determine the wait mode. Where you set this depends on the component/access technology you are using. Carlos Firebird Performance in Detail - <http://videos.firebirddevelopersday.com> http://videos.firebirddevelopersday.com <http://www.firebirdnews.org> www.firebirdnews.org - <http://www.FireBase.com.br> www.FireBase.com.br Hi Carlos. Where do I chage it? Hugo Em 18/08/2014 15:06, 'Carlos H. Cantu' <mailto:lis...@warmboot.com.br> lis...@warmboot.com.br [firebird-support] escreveu: To avoid such error, try to change the DDL transaction parameter to WAIT instead of NO WAIT. Carlos Firebird Performance in Detail - <http://videos.firebirddevelopersday.com> http://videos.firebirddevelopersday.com <http://www.firebirdnews.org> www.firebirdnews.org - <http://www.FireBase.com.br> www.FireBase.com.br HEhmcfs> Hello. HEhmcfs> IBExpert shows the message: HEhmcfs> lock conflict on no wait transaction HEhmcfs> unsuccessful metada update HEhmcfs> object MY_PROCEDURE is in use HEhmcfs> How can I see 'who' is using the procedure? -- Atenciosamente, Hugo Eyng -- Atenciosamente, Hugo Eyng