Re: Online Record Locking during updates

MSaltzmann@gnn.com (MICHAEL SALTZMANN) wrote: >I have a problem that my programmer cant seem to >conceptually solve. We have a plant floor that >updates the status of parts moving from one department >to another and an accounting department that runs updates >to the open records. >The account dept's updates crash when they encounter >a record that is open for update and does not continue. >Could anyone help me out with an idea of what we could do? >Thanks... Hi! How about using SET LOCK MODE TO WAIT? If you're using OnLine, you can even SET LOCK MODE TO WAIT xxx, where xxx is the number of seconds to wait. HTH. -- Cheers, Billy ----------------------------------------------------------------------------- INCLUDE "Disclaimer.4gh" -- my opinions are INCLUDE "FlamesToDevNull.4gh" -- flamers, eat my shorts! INCLUDE "CaveatEmptor.4gh" -- take my advice at your own risk INCLUDE "ThirtySomething.4gh" -- header file for this class -- Written by : Billy Wheeler, Date: today -- Copyright (c) 1995, The West Solutions Group