RE: Stored Proc. 7 Row locking?

Neil, I haven't tested this so you might want to... I believe all you need to do is name the cursor. For example, FOREACH curs_name. Since you could then use the cursor's name in an update statement, I believe that the row would have to be locked. This would be similar to (in 4GL) declaring a cursor for update. --Craig (craig@chemistry.utah.edu) > > How do you do it? > > I want to read a row, update another table, modify the original data, > and stampe it back. How do I lock the first row while I am doing the biz? >