How about: use &filename order thisorder in select([bob]) again
I don't recall if the SELECT() function supports the alias reference back in VFP 6. Of course this begs the question of how often &filename is being opened under how many aliases and whether or not your code cares if it gets closed and reopened by the above. -- rk -----Original Message----- From: ProfoxTech [mailto:[email protected]] On Behalf Of Desmond Lloyd Sent: Wednesday, April 17, 2013 2:10 PM To: [email protected] Subject: VFP6: File is in Use Error Have this old application with "if used" code in it.... Essentially, if .not. used(bob') select 0 use &filename order thisorder alias bob endif Problem is that is occasionally blows up with a file in use error when it uses &filename. "bob" is not used so it barges on, so &filename is in use. How do I determine the alias that &filename is used under? As a stop gap measure am going to include a direct reference to filename. Have tried different ways to duplicate the users problem but no joy. Am sure I am overlooking the obvious so any thoughts/suggestions would be greatly appreciated.... TIA/Regards, Desmond _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/DF1EEF11E586A64FB54A97F22A8BD0442190B374B3@ACKBWDDQH1.artfact.local ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
