Re: Table locks
Posted in 1995
Rob McAllister — — source: Informix-list mailing list archive (1991-1998)
marco greco <mar.greco@agora.stm.it> wrote:
>As read from the 4gl reference manual:
>Lock Table
><Cut>
>
>lock table tbl in <whatever> mode
>declare curs1 cursor for
> select * from tbl #It's just an example, Mark!>foreach curs1 into some_var
>..
>end foreach
>..
>..
>..
>unlock table tbl
>Marco.
Are you using a commit work before the unlock table? That will cause the lock
to be removed.
--------------------------------------------------------
Rob McAllister rmcall@on-ramp.ior.com
Spokane, WA
"On all good programmers a little core must dump"