[ic] Foreign Key

[Jamie Neil]

> -----Original Message-----
> From: interchange-users-admin@icdevgroup.org
> [mailto:interchange-users-admin@icdevgroup.org]On Behalf Of Alberto
> Speggiorin
> Sent: 03 June 2003 16:39
> To: interchange-users@icdevgroup.org
> Subject: [ic] Foreign Key
>
>
> Hi all,
> I am new to IC and I was looking for info about the implementation of
> the foreign keys since I am using Postgresql db.
> I found this note in the ictags [data]  tags reference:
> Foreign Keys  Russell Mann
>
> An undocumented feature is the foreign key: [data table=table
> column=column key=key foreign=foreign] will work if there is only one
> corresponding entry in the database.
>
> I was wondering if someone knows if  there the change to use more than
> one foreign keys and if this option foreing is working.
> TKS

Hi Alberto,

I can confirm that the feature described above does work. I have used it a
number of times to replace the query tag where I know the field is unique
(only one match).

I don't think you can specify more than one foreign key, but to be honest I
haven't tried it or examined the code and as this feature is undocumented,
the code is where to look. Assuming not, you can always use the query tag
which gives you far more control over your SQL.

Jamie

>
> Alberto
>
>
>
> _______________________________________________
> interchange-users mailing list
> interchange-users@icdevgroup.org
> http://www.icdevgroup.org/mailman/listinfo/interchange-users
>