I found the solution myself
In order to save the change i have to use: update_record
On Nov 30, 12:07 pm, thodoris <pasxi...@gmail.com> wrote:
> I have this field
>
> db.define_table('B',
> Field('my_table', db.A, notnull=False, ondelete="SET NULL"),
>
> db.B.my_table.requires = IS_EMPTY_OR (
> IS_IN_DB(db(db.A.author_id==auth.user_id),
> db.A.id, '%(title)s'))
>
> That means that my_table can have references from A but only the ones
> that the same user has made OR is empty (None). And also when the
> referenced object is deleted the value becomes None.
>
> What i want to do is to remove a reference at some point. I have the
> id of the entry i want to change and i do
>
> db.B[id].my_table = None
>
> but it doesn't work. Actually it doesn't allow me to change it from a
> function. Do i do something wrong?
