Richard, Thanks for your reply. Yep, I set the migrate=False at DAL level so that I don't have to specify each table.
> If you use crud and you define permissions, just don't give update, delete > and create rigths (so just read and select, maybe). > > About the not lock any record, I don't know how it works exactly, but I > think that if you only use read and select there will be not lock (to be > confirmed). Yeah, that's kind of what I thought. As long as I'm SELECTing it's should not lock the record but I wasn't sure. On Nov 1, 9:31 am, Richard Vézina <[email protected]> wrote: > migrate=False > > If you use crud and you define permissions, just don't give update, delete > and create rigths (so just read and select, maybe). > > About the not lock any record, I don't know how it works exactly, but I > think that if you only use read and select there will be not lock (to be > confirmed). > > Richard > > > > > > > > On Tue, Nov 1, 2011 at 10:25 AM, Omi Chiba <[email protected]> wrote: > > I'm connecting existing tables on DB2 which is for a mission critical > > system. I just want to read them and don't want to lock any record on > > the tables. > > > Shoud I explicitly put readonly or it doesn't matter if I don't use > > like crud.update ?? > > > My definition for existing table > > ----------------------------------------- > > db.define_table('SDTH2L01', > > Field('H2DNO', length=8), > > Field('H2JDNO', length=8), > > Field('H2JGNO', 'integer'), > > Field('H2PRCD', length=15), > > Field('H2PRKJ', length=50), > > Field('H2TRS', 'integer'), > > Field('H2HZS', 'integer'), > > primarykey=['H2DNO'])
