HELP: ESQL/C Update Cursor Error

1 2 3 4 5 6 7 1234567890123456789012345678901234567890123456789012345678901234567890 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. The update is actually quite simple, read the record, increment the value and then update the record. After updating the record the cursor is closed, thus removing any locks. Sounds simple, huh? The problem is that I can only seem to get SQL error 263 with ISAM error 143. After repeated attempts, 50 a three second pause and then ten more retries, I can only come up with the dreaded deadlock timeout. All of this is accomplished in under 10 seconds! What happened to the 118 second wait timeout? Any ideas? Suggestions? I am using On-Line 5.02.UC6x1, ESQL/c 5.01 and 4GL 4.11.UC1. Your help is greatly appreciated! Albert E. Whale aewhale@emi.lm.com ---------------------------------------------------- Sr. Systems/Database Consultant Executive's Monitor, Inc. 1789 S. Braddock Ave, Ste 220 Pittsburgh, PA 15218-1868 (412)243-4600 Fax: (412)243-4830