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

-- 



Reply via email to