Re: How do "locks" work when doing deletes?

> SE V5.01 etc only: > > if the database has TRANSACTIONS then deletes are logged. You will need one > kernel lock per delete! > > LOCKing the TABLE does not reduce the lock requrement. So you need to turn off > TRANSACTIONs before doing mass deletes. Any one know a quick cheap way of > doing this? - apart from editing the systables definition? > I think they recommend working with cursors acting on the select statement which yields the rows you want to delete, with Begin/Commit Work commands executed after a number of records have been processed.