There is a solution in trunk. Please give it a try.
On Wednesday, 25 July 2012 20:36:07 UTC-5, tomt wrote:
>
> Hi,
> I was using a version of trunk. I downloaded today's version and got the
> same error. I opened a ticket as suggested. (Issue 908)
>
> On Wednesday, July 25, 2012 7:38:47 AM UTC-6, Massimo Di Pierro wrote:
>>
>> Please open a ticket. This can be fixed if not fixed already. Using trunk
>> or stable?
>>
>> On Tuesday, 24 July 2012 23:28:29 UTC-5, tomt wrote:
>>>
>>> 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
>>>
>>
--
