Hi,
I have an id field which is not named 'id'. Here's a part of
definition:
Category = db.define_table('category',
Field('myid', 'id'),
Field('id', 'integer'),
Field('parent_id', 'integer') ...
I want to make SQLFORMs for updating existing values:
update_forms = db(Category.parent_id == category_id).select()
for update_form in update_forms:
f = SQLFORM(Category, update_form.myid, ...)
Seems that SQLFORM tries to select entry with Category.id, not with
Category.myid.
In this case 'id' is not primary nor AI field, is it a bug or...?
Any suggestions?
I can't use id field because it's not unique.
If it cannot be done, i'll rename myid to id, and id to sth else, but
I wanted to report this at least.
