On 4/23/2012 5:25 PM, Michael Madigan wrote: > 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.
Not sure. My only advice is to change it to this: REPLACE post_date WITH date() FOR post_date <> date() ALL in YourTableName Also, if that replacement is happening in the Payment table, why would you want to open it with NOUPDATE? hth, --Mike -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 _______________________________________________ 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.
