>>It seems that if I execute this statement:
>>{select name,noun from m:1sn where STATUS = 'CANC' into array elephant}
>>it keeps the file 1SN.dbf open. Do I have to issue a "use in 1sn"? to free it?
>
>Yes, foxpro keeps all tables listed in FROM or JOIN clauses of select open regardless if they were open before SELECT or not. Unfortunatelly "use in 1sn" wouldn't work because alias in foxpro cannot start with number. Your 1sn.dbf would be open with alias A-J in first 10 work areas or Wnn in higher. If you want to control that open your table before SELECT with alias, for example

>USE 1SN ALIAS _1SN
>SELECT FROM _1SN ...
>USE IN _1SN

Just like I suspected. SO I added the "unuse" code and it works. Thing is, in the application just after this code executes, I go in my server mgr(NT ADMIN) and look to see what files I have open and it still shows this files as being open for another 60-120 seconds. I keep hitting refresh and the file drops off. I guess it's a timing thing with server mgr.

"Build a man a fire, and he's warm for a day.    
Set a man on fire, and he's warm for the rest of his life."