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
--
