I do not know how well that works. Please let us know if there is any
problem.
On Wednesday, 25 July 2012 22:42:39 UTC-5, tomt wrote:
>
> More good news. I discovered that this fix now allows me to use
> SQLFORM.grid on legacy tables that don't have an 'id' field!
>
> On Wednesday, July 25, 2012 9:10:38 PM UTC-6, tomt wrote:
>>
>> I tried the latest trunk, and it solves the problem I described. This is
>> great and it will make it much easier for me to interact with my legacy
>> tables.
>> I also have to thank you for the amazingly fast fix!!!
>> Thanks a lot - Tom
>>
>> On Wednesday, July 25, 2012 8:14:14 PM UTC-6, Massimo Di Pierro wrote:
>>>
>>> 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
>>>>>>
>>>>>
--
