RE: Online Record Locking during updates

Michael, Sheesh, a few clues might help. For example, what engine are you using (c-isam, standard or OnLine), what programming language (esql/c, 4gl, powerbuilder, etc), what error are you encountering, what does the program say when it crashes, etc. In general though, you have a few options when you come accross a locked row. You might sit and wait for the row to become unlocked (lock mode wait...), you might rollback and try again, you might give an error, you might crash (<- the option your programmer seems to have choosen). If you provide more details, I can give you better advice. --Craig (craig@chemistry.utah.edu) > > 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? >