In your example when row_a is deleted row_b is unaffected BUT when the form
is next visualized the link that no longer exists will disappear.
For normal reference the default is ON DELETE CASCADE and linked records
are deleted. For list:references the linked records are NOT deleted
On Thursday, 4 April 2013 18:12:57 UTC-5, Luca wrote:
>
> Suppose I have:
>
> db.define_table('table_a',
> Field('name'),
> )
>
> db.define_table('table_b',
> Field('my_a', 'list:reference table_a'),
> )
>
> I create a row_a in table a, and I put its id as member of the list my_a
> in row_b of table_b.
>
> Suppose I then delete row_a. What happens?
>
> 1. row_b is unaffected
> 2. The reference to row_a in field my_a of row_b is removed
> 3. row_b is removed
> 4. Other?
>
> Many thanks, Luca
>
>
--
---
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.
For more options, visit https://groups.google.com/groups/opt_out.
