Re: HELP: ESQL/C Update Cursor Error
Posted in 1994
At 01:28 AM 12/16/94 GMT, aewhale@emi.lm.com wrote: >I am trying to implement database locking in a Production application >which currently only implements locking via application. In order to >do this I am first implement (or trying to) implement cursor stability >with lock mode wait 118 for a declared cursor for update. > >Any ideas? Suggestions? > Try setting lock mode on the table to ROW, instead of default PAGE. This should reduce the likelyhood of deadlocks (if table is not already set at ROW level locking). Also, setting lock wait, will not do much good, if a deadlock condition is impending..... Jon ================================================================== Jon Vemo Internet: jvemo@cyberspace.com Bothell, WA USA ------------------------------------------------------------------ Watch out for road-kill on the information superhighway....SPLAT!! ==================================================================