>when I open a table:
>
>

>use stock in 0
>

>
>I always got error message: File is in use
>
>how can I detect the table is in use, so I can close it before.
>
>thanks for the help
>
>regards,
>
>Jerry

if not used('Stock')
   use Stock in 0 alias Stock again shared
endif

If you always want to close it first, then

use in select('Stock')

use Stock in 0 alias Stock again shared