Try using parens instead:
use (filename) order ThisOrder in select("Bob") again
Just a wag....
On 4/17/2013 2:17 PM, Richard Kaye wrote:
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
[excessive quoting removed by server]
_______________________________________________
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/[email protected]
** 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.
