Tools that don't support Many-2-Many out of the box, you have to create the third [middleman] table yourself. Does Aware support M-2-M out of the box and create the third table for you automatically? I tried every which way, but no luck.
If no, will this be offered in 7.1?
Thanks!
►Q◄ Does Aware support Many-2-Many out of the Box?
Re: ►Q◄ Does Aware support Many-2-Many out of the Box?
Sure it does Ben. If you have a relationship with "multiple" on both attributes, then aware creates the "middle" table.
Bruce
Bruce
Re: ►Q◄ Does Aware support Many-2-Many out of the Box?
Bruce, these relationships were "OwnedBy" and I could not get aware to give me the "multiple allowed" option. So, no middle was created.BLOMASKY wrote:Sure it does Ben. If you have a relationship with "multiple" on both attributes, then aware creates the "middle" table.
Bruce
Re: ►Q◄ Does Aware support Many-2-Many out of the Box?
Clarification - When the M-2M is created I don't see a new object created that combines the two. That's what I meant. Because I will need that object later on in my queries to search upon.BLOMASKY wrote:Sure it does Ben. If you have a relationship with "multiple" on both attributes, then aware creates the "middle" table.
Bruce
For example when I'd create a m-2-m in .Net, I would have a new object (not just a table in DB) that I could deal with in the code. I don't see that object in Aware.
Re: ►Q◄ Does Aware support Many-2-Many out of the Box?
Peer multiple reference attributes are obviously possible, and two objects can be peer multiple's of each other.
But, shortcut attributes won't be possible in this scenario.
But you can setup an intermediate object to be a 'carrier' of another.
Why don't you outline an example of what you want to achieve using 'objA' and 'objB' as pawns in your example, so more comment/suggestions can be forthcoming?
But, shortcut attributes won't be possible in this scenario.
But you can setup an intermediate object to be a 'carrier' of another.
Why don't you outline an example of what you want to achieve using 'objA' and 'objB' as pawns in your example, so more comment/suggestions can be forthcoming?
Re: ►Q◄ Does Aware support Many-2-Many out of the Box?
I've already gone through the route of middleman or carrier, because I get an object to work with and also I get to have shortcuts, which is a must. Peer relation is no good in this case. I also need to store another attribute called Counts which forces me to create my own middleman object. I thought Aware creates that object, but it only creates the DB table for it's use.pureist wrote:Peer multiple reference attributes are obviously possible, and two objects can be peer multiple's of each other.
But, shortcut attributes won't be possible in this scenario.
But you can setup an intermediate object to be a 'carrier' of another.
Why don't you outline an example of what you want to achieve using 'objA' and 'objB' as pawns in your example, so more comment/suggestions can be forthcoming?
Re: ►Q◄ Does Aware support Many-2-Many out of the Box?
Perhaps you could get support to make the table available since it is created??I thought Aware creates that object, but it only creates the DB table for it's use.
Tom - V8.8 build 3137 - MySql / PostGres
-
- Posts: 2400
- Joined: Mon Jul 02, 2012 12:24 am
- Location: Ulaanbaatar, Mongolia
Re: ►Q◄ Does Aware support Many-2-Many out of the Box?
Connect to it as an external table?
Cheers,
Mark
_________________
AwareIM 6.0, 8.7, 8.8, 9.0 , MariaDB, Windows 10, Ubuntu Linux. Theme: Default, Browser: Arc
Upcloud, Obsidian....
Mark
_________________
AwareIM 6.0, 8.7, 8.8, 9.0 , MariaDB, Windows 10, Ubuntu Linux. Theme: Default, Browser: Arc
Upcloud, Obsidian....
Re: ►Q◄ Does Aware support Many-2-Many out of the Box?
That should prove to be even easier to do as support has indicated that external files will have even greater functional support soon.Connect to it as an external table?
Tom - V8.8 build 3137 - MySql / PostGres
Re: ►Q◄ Does Aware support Many-2-Many out of the Box?
I have to see if I really want to deal with table as "external" table or as a first-class-citizen object made in Aware (where I can use it throughout)tford wrote:That should prove to be even easier to do as support has indicated that external files will have even greater functional support soon.Connect to it as an external table?
If Aware was giving me back and object then that would be great.