[Catalyst] Using Catalyst on MS SQL DB that has tables with no primary keys

Robert Wohlfarth rbwohlfarth at gmail.com
Fri Sep 14 18:11:37 GMT 2012

On Fri, Sep 14, 2012 at 11:43 AM, Derek W <derekwrobel at gmail.com> wrote:

> The problem is our database structure here.  The 3 tables I need to
> use do not have any relationships set.  There is no primary keys on
> these tables.  I had to manually code the relationships between the
> tables because the create helper could not - obviously.  Now that I'm
> getting to the point of trying to add functionality such as deleting,
> Catalyst seems to blow up because it requires primary key for such
> calls as action_for('delete').

I ran into something similar where I work. In the model code, I defined an
auto number field as the primary key. That makes DBIx::Class happy.

-- =

Robert Wohlfarth
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/catalyst/attachments/20120914/5e989=

More information about the Catalyst mailing list