Many to many relationship strange behaviour

A place for users and developers of the Xataface to discuss and receive support.

Many to many relationship strange behaviour

Postby silma » Fri Sep 02, 2011 1:09 am

Hello Steve, Hello all Xataface users there ,

I noticed a strange behaviour with a many to many relationship ; I could not say if it occured since version 1.3rc5 or since 1.3rc6.

I used to have my relationship between my tables "batiment" and "compteur" in \tables\batiment\relationship.ini file defined like that :
Code: Select all
[Compteurs]
__sql__ = "SELECT * FROM compteurbatiments cb INNER JOIN compteur c ON (cb.CompteurID = c.CompteurID and cb.BaseID = c.BaseID ) WHERE cb.BatimentID = '$BatimentID'   "

action:order=4
vocabulary:existing = Compteurexistant
action:visible=0

Untill recently, it worked.
Now, when i do "Add existing record", it duplicate the "compteur" record.

I replace the relationship in \tables\batiment\relationship.ini file with :
Code: Select all
compteur.CompteurID =compteurbatiments.CompteurID
compteurbatiments.BatimentID = "$BatimentID"
compteurbatiments.BaseID = "$BaseID"

action:order=4
vocabulary:existing = Compteurexistant
action:visible=0

It works again.

I just wanted to report it, if it can be useful for someone (or if i made a mistake before that can be pointed out !)

Sorry for my poor english,

Silma
silma
 
Posts: 87
Joined: Tue Apr 28, 2009 11:47 pm

Return to Xataface Users

Who is online

Users browsing this forum: No registered users and 25 guests

Powered by Dataface
© 2005-2007 Steve Hannah All rights reserved