Re: [Sqlpp-devel] reference in same table

[Jonathan de H. <deh...@au...>]

When you can a foreign-key, sqlpp adds all the primary-key fields to the 
linked table without altering the names. Now this approach does not work if 
you link "twice" the same table or you are doing a self-reference.

In that case, you can use reference/@field-prefix to tag the name of the 
added fields. For example, field-prefix="Parent" will lead to field: 
ParentUserID and so on.

In your case:
<reference id="ref_myBoss" ref-table="users" field-prefix="Parent" 
nullable="true" />

At 14:41 24/04/2004 +0200, you wrote:

>Hi!
>Can I implement a reference from a foreign key  to a  primary key field
>in the same table?
>I try the something like this:
><table id="users" name="Users" field-prefix="User" qualifier="test_" 
>fixed="false" signed="false" suffix="">
>            <field id="userid" name="ID" type="int" primary-key="true" />
>            <!-- <field id="bossid" name="bossID" type="int" /> -->
>            <field id="username" name="Name" type="NVARCHAR(30)" 
> nullable="false" />
>            <field id="userlastname" name="LastName" type="NVARCHAR(30)" 
> nullable="true" />
>            <reference id="ref_myBoss" ref-table="users" field-prefix="" 
> nullable="false" match="userid" name="bossid" />
>            <!-- <reference id="ref_myBoss" ref-table="users" 
> field-prefix="" nullable="false" name="bossid"/> -->
></table>
>but I get error that a "duplicate field name while creating foreign keys" 
>was found.
>Could you help me?
>
>What make the match and name attribute in reference-type tag exactly?
>
>Thank you!
>
>
>-------------------------------------------------------
>This SF.net email is sponsored by: The Robotic Monkeys at ThinkGeek
>For a limited time only, get FREE Ground shipping on all orders of $35
>or more. Hurry up and shop folks, this offer expires April 30th!
>http://www.thinkgeek.com/freeshipping/?cpg=12297
>_______________________________________________
>Sqlpp-devel mailing list
>Sql...@li...
>https://lists.sourceforge.net/lists/listinfo/sqlpp-devel

-----------------------------------------------------------------------------------
Jonathan de Halleux, Research Assistant
Center for Systems Engineering and Applied Mechanics (CESAME)
Universite catholique de Louvain
Batiment Euler , Av. Georges Lemaitre, 4 Tel : +32-10-47 2595
B-1348 Louvain-la-Neuve Belgium
E-mail : deh...@au...
-----------------------------------------------------------------------------------