FB
De: [email protected] [mailto:[email protected]] Enviada em: segunda-feira, 18 de agosto de 2014 16:47 Para: [email protected] 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' [email protected] [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:[email protected]> [email protected] [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
