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

Hi Joe

Have you tried removing the OrdListClear line - given that DbCloseArea closes the index as well?

Patrick D'Arcy

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
>

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

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
>>
>