On 6 July 2011 15:01, Dave Howorth <[email protected]> wrote:
> I have a DBIC class made up using a UNION, something like this
> __PACKAGE__->result_source_instance->is_virtual(1);
> __PACKAGE__->result_source_instance->view_definition(
> "SELECT
> sp_id AS id,
>
> ...
> I've discovered that this doesn't work:
>
> $node_rs->search({status => 'obsolete' })->delete;
>
>
I thought you couldn't Delete through a View in most databases?
Regards, Peter
_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/[email protected]
