function to check whether file is already open 1

[fbizzell]

Is there a clipper or 3rd party function that checks to see if the program already has a file open. I sometimes get an error that "alias does not exist". It is usually because I have opened a user area and then closed it when I should have left it open. I want to be able to check whether the file is open when I try to use it and if it is not I then can open it.

 

[GriffMG]

I usually test to see if a field in the table is 'visible'...

IF TYPE("MyTable->MyField") = "U"
  SELECT 0
  USE MyTable
ENDIF

Regards

Griff
Keep [Smile]ing

 

[fbizzell]

Thanks. I will give that a try.

 

[TonHu]

Better would bet to try

IF Select(cDataFile) = 0
  SELECT 0
  USE (cDataFile)
ENDIF

HTH
TonHu

 

[fbizzell]

Thanks TonHu, I will give that one a try as well and see if it works for me.