Author | Topic: DbCloseArea() locks up the App - HELP!!! | |
---|---|---|
Joe Carrick | DbCloseArea() locks up the App - HELP!!! on Fri, 23 Jul 2010 12:17:39 -0700 Something strange is happening. I use this subroutine to close a work area. //////////////////////////////////////// PROCEDURE NetClose( cAlias ) IF !empty(select(cAlias)) (cAlias)->(OrdListClear()) (cAlias)->(DbCloseArea()) ENDIF RETURN //////////////////////////////////////// Essentially, there's nothing magic about it. It simply checks to see if the alias exists and if so closes the index and database. Today, we are finding that it sometimes locks up the app - Task Manager reports "Application is not Responding". It's acting like it is caught in a loop but I have no idea why. I have isolated it to the call to DbCloseArea(). The App works fine, many times calling this routine but a a certain point in the program it fails to return from the DbCloseArea function. Does anyone know how to get around this? Xbase++ version 1.90.331 Thanks, Joe | |
Patrick D'Arcy | Re: DbCloseArea() locks up the App - HELP!!! on Fri, 23 Jul 2010 23:52:19 +0200 Hi Joe Have you tried removing the OrdListClear line - given that DbCloseArea closes the index as well? Patrick D'Arcy | |
Joe Carrick | Re: DbCloseArea() locks up the App - HELP!!! on Fri, 23 Jul 2010 15:22:52 -0700 Yes, I did try that. I did something else that seems to have fixed the problem - I removed a line earlier in the program: ' set order to tag "Company" ' Why that should solve the problem is totally beyond my comprehension. I'm positive that the problem exists within the DbCloseArea() function and I'm also confident that it is a loop condition. There is no runtime error nor is there any SPT. The only way to find what really caused it would be to examine the DbCloseArea() code. AFAIK, only Alaska has access to that code. -Joe On 7/23/2010 2:52 PM, Patrick D'Arcy wrote: > Hi Joe > > Have you tried removing the OrdListClear line - given that DbCloseArea closes the index as well? > > Patrick D'Arcy > | |
Bruce Carroll | Re: DbCloseArea() locks up the App - HELP!!! on Sat, 24 Jul 2010 19:40:04 +0100 Joe, I have experienced this problem - I had to do a 'close' on each open db going from the child/related db's first and working back up to the main db. I believe DbCloseArea() does not work correctly if active indexes are open that relate to other files. HTH Best regards, Bruce On 23/07/2010 23:22, Joe Carrick wrote: > Yes, I did try that. > > I did something else that seems to have fixed the problem - I removed a > line earlier in the program: > > ' set order to tag "Company" ' > > Why that should solve the problem is totally beyond my comprehension. > I'm positive that the problem exists within the DbCloseArea() function > and I'm also confident that it is a loop condition. There is no runtime > error nor is there any SPT. The only way to find what really caused it > would be to examine the DbCloseArea() code. AFAIK, only Alaska has > access to that code. > > -Joe > > On 7/23/2010 2:52 PM, Patrick D'Arcy wrote: >> Hi Joe >> >> Have you tried removing the OrdListClear line - given that DbCloseArea >> closes the index as well? >> >> Patrick D'Arcy | |
Jorge L | Re: DbCloseArea() locks up the App - HELP!!! on Sat, 24 Jul 2010 17:18:23 -0300 Hi to all remember my thread "Joe Carrick" <joe.carrick@dslextreme.com> escribió en el mensaje de noticias:123cf947$176533cb$2a7a5@news.alaska-software.com... > Yes, I did try that. > > I did something else that seems to have fixed the problem - I removed a > line earlier in the program: > > ' set order to tag "Company" ' > > Why that should solve the problem is totally beyond my comprehension. I'm > positive that the problem exists within the DbCloseArea() function and I'm > also confident that it is a loop condition. There is no runtime error nor > is there any SPT. The only way to find what really caused it would be to > examine the DbCloseArea() code. AFAIK, only Alaska has access to that > code. > > -Joe > > On 7/23/2010 2:52 PM, Patrick D'Arcy wrote: >> Hi Joe >> >> Have you tried removing the OrdListClear line - given that DbCloseArea >> closes the index as well? >> >> Patrick D'Arcy >> > |