Hi Anthony,
Now I faced a new problem, I have another tabel who has not the id filed,
following your suggestions I defined a primarykey:
legacy_db.define_table('timesheet_times',
Field('uid', 'string'),
Field('start_time', 'datetime'),
Field('end_time', 'datetime'),
Field('trans_num', 'integer'),
Field('proj_id', 'integer'),
Field('task_id', 'integer'),
Field('log_message', 'text'),
primarykey=['trans_num'],
migrate=False)
But when i try to read the legacy_db content in my controller using this:
times =
legacy_db(legacy_db.timesheet_times).select(orderby=legacy_db.timesheet_times.trans_num)
I got the error:
<type 'exceptions.KeyError'> '_id'
--
