With VFP9 the AUSED() function has a new parameter to determine this one, but in the meanwhile you will have to use your own UDF:
Function IsDBFused
LPARAMTER tcDBF
LOCAL llIsUsed
llIsUsed = .F.
TRY
USE (tcDBF) IN 0 EXCLUSIVE
CATCH
llIsUsed = .T.
FINALLY
USE IN (SELECT(tcDBF))
ENTRY
RETURN llIsUsed
HTH
>i just found out other program opened that table with different alias and that's what causing the problem.
following code should reproduce error for anyoneUSE nir
USE nir ALIAS nira
SELECT * from nir INTO CURSOR c1 readwrite
USE IN SELECT('c1')
USE IN SELECT('nir')
USE nir >i am wondering is there any way to find out if a table is open with different alias
