Re: Locking on Informix

You can use isolation levels. Both cursor stability and repeatable read will place locks when you read data. You can also use update cursors when you intend to update records. -Bill } } Centura 1.1.1. PATCH 2 } NT-Client 4.0 } Informix On-Line 7.22C1 } Windows NT 3.51 } } We are using Centura 1.1.1. on an Informix On-Line Database. } We added an extra field on every table to check the locking. } That field contains the current (03-12-1997 12:30:25.000). } The moment that you try to do the update, we are checking } if another user has changed the record since we have that } record on the screen using that datetime field. } If the record has been changed, the user gets a warning } on the screen : Record has been changed by another user ! } Windows NT never gives you the fractions of seconds. If } two users do the update on the same second, the system } doesn't give you the warning ! } } How do you check locking on Informix ? } } } Franky Thiel } INFOHOS@UNICALL.BE } } } -- Bill Ennis Voice: 312-474-7516 SSA Fax: 312-474-7460 500 W. Madison email: ennis@ssax.com ennis@accesschicago.net