You got a mess... First never use FLock(). For the guys who just read, open the file as readonly. You should use a Cursor or a View to hold the data, then you replace in the View or Cursor. After that you use Begin Transaction Tableupdate ... END TRANSACTION or ROLLBACK.
If you need to use RLOCK(), use something like; DO WHILE NOT RLOCK() INKEY(.02,"H") ENDDO HTH, E. > most of the users have a screen where they can view the payments but not > change them >> >> one user has super user status and is allowed to add payments and post >> payments. >> >> The second user is constantly receiving error messages that "file is in use >> by another" . >> >> Shouldn't I be able to let the first set of users see the payments without >> affecting the second user at all? >> >> Shouldn't "use payment noupdate" fix that issue? >> >> >> I don't understanad why some function seem to allow for a >> >> scan >> >> replace post_date with date() >> >> endscan >> >> to work without a hitch while other functions seem to blow up completely and >> require an FLOCK() to allow it to operate without errors. In order to >> work with flock(), the other users have to be out of the program. > > > --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://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.
