I use several legacy tables in my web2py applications A typical definition that I use is: db2.define_table('analogpoint', Field('pointnumber','integer',writable=False), Field('pointname','string',writable=False), primarykey=['pointnumber'], migrate=False )
I can access this table with DAL: info = db2(db2.analogpoint.pointnumber == point) \ .select(db2.analogpoint.pointnumber,db2.analogpoint.pointname) but the following method generates an error: temp = db2.analogpoint[1].pointname KeyError: '_id' Is there a way to use this method on a table that doesn't have an 'id' field I have had success when I generate a view that includes an 'id' field for every legacy table, but I would like to avoid this if possible. - Tom --