Just a WAG...
Explicitly change to that workspace (select DBFNAME) or include "in
DBFNAME" at the end?
Delete for xyz in dbfname
As a kludge, you might do a short routine...
select dbfname
go top in dbfname
locate for xyz
scan while !eof('dbfname')
delete if xyz in dbfname
ends
While it won't be as fast as "delete for xyz in dbfname" you'll be
surprised how fast it can process through the file.
Mike
-------- Original Message --------
Subject: DELETE - File in use by another
From: Christina Bull <[email protected]>
To: [email protected]
Date: 4/16/2013 10:11 PM
Hi all,
Hopefully someone can answer this reasonably quickly as I'm onsite and
having a brain fart.
Getting Error #3 - File in use by another - and I'm working on a multi-user
system. It's falling over on command that looks like:
DELETE FOR xyz
Should I be changing that to a DELETE - SQL instead?
What's the best way to flag a record for deletion in a multi-user
environment? Should I try and get a record lock first?
I'm moving out of development in VFP very soon and into full time Sales role
for an offset printing / direct mailing company. Can't wait!
Christina
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
[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.
