On Tuesday, August 20, 2019 at 2:32:54 AM UTC-7, Deep Shah wrote:
>
> Data is coming from data source which is cannot be editted and hence
> cannot add id in table . So is there any other way where i can use table
> with primary keys?
>
>
Take a look at
<URL:http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Legacy-databases-and-keyed-tables>
If one of your fields is an auto-increment integer field, you can make it
as type 'id'.
Otherwise, maybe "keyed table" will work for you (using a composite of
fields that make up the primary key).
You didn't say which DB you have for backend (or did I miss it?) but your
DB engine may have been added to the list since that part of the book was
updated.
/dps
On Tuesday, August 20, 2019 at 11:46:04 AM UTC+5:30, Johann Spies wrote:
>>
>>
>>
>> On Tue, 20 Aug 2019 at 07:00, Deep Shah <deep...@loylty.com> wrote:
>>
>>> Hi All,
>>> I am migrating table from existing table which has primary key with two
>>> fields.
>>> After migrating the table i created SQLFORM.grid and used selectable to
>>> process the selected tuples.
>>> selectable = [('Approve Selected names', lambda ids: approve_name(ids))]
>>>
>>> Its giving the following error.
>>> <type 'exceptions.AttributeError'> 'Table' object has no attribute '_id'
>>>
>>> How do i solve this error keeping both field as key
>>>
>>>
>> Just add an id-column as a serial field. It is not necessary for it to
>> be the primary key. If you need to use the primary key for references, use
>> executesql.
>>
>> Regards
>> Johann
>> --
>> Because experiencing your loyal love is better than life itself,
>> my lips will praise you. (Psalm 63:3)
>>
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/web2py/c97c31a5-4e65-408a-89a5-185f3819bd68%40googlegroups.com.
