Relacionamento Muitos-para-muitos


Author
Message
Malcon M. Mikami
Malcon M. Mikami
StrataFrame User (164 reputation)StrataFrame User (164 reputation)StrataFrame User (164 reputation)StrataFrame User (164 reputation)StrataFrame User (164 reputation)StrataFrame User (164 reputation)StrataFrame User (164 reputation)StrataFrame User (164 reputation)StrataFrame User (164 reputation)
Group: Forum Members
Posts: 60, Visits: 1.3K
Bom dia, fiz uma aplicaçao de teste para ver o relacionamento multiplo.

Possuo 3 tabelas  Fornecedor, FornecedorProduto, Produto.

Quando faço o relacionamento 1..*(Match) entre FornecedorProduto - Produto ele retorna a linha selecionada.

Quando faço *..* (Cascate) entre FornecedorProduto - Produto ele nao retorna nada. Oque pode ser?

Nas imagens, o sistema com o relacionamentos e os resultados.

Attachments
match.JPG (142 views, 215.00 KB)
cascate.JPG (140 views, 225.00 KB)
Replies
Malcon M. Mikami
Malcon M. Mikami
StrataFrame User (164 reputation)StrataFrame User (164 reputation)StrataFrame User (164 reputation)StrataFrame User (164 reputation)StrataFrame User (164 reputation)StrataFrame User (164 reputation)StrataFrame User (164 reputation)StrataFrame User (164 reputation)StrataFrame User (164 reputation)
Group: Forum Members
Posts: 60, Visits: 1.3K
Sorry friends, but my English is weak. In the coming posts I put the translation into English.
 
Ivan, agora não entendi nada. Qual a diferença entre CascadeRowFilter e MatchCurrentRow, você poderia me falar um exemplo prático?

 
Ivan, now do not understand anything. What is the difference between CascadeRowFilter and MatchCurrentRow, you could tell me a practical example?

Trent Taylor
Trent Taylor
StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 6.9K
The MatchCurrent row will only filter out records on the child BO that match the parent relationship.  For example,

Parent BO

PrimaryKeyName
1ABC Vending
2XYZ Autos
3Zenith Auto Sales

Child BO

PrimaryKeyParentForeignKeyOrderTotal
11$15.00
21$20.00
32$40.00
43$10.00

So using the tables above, if the ParentBO is using MatchCurrentRow, and the CurrentRowIndex is on the PK record of "1", then the ChildBO would filter out all records except the records with a PK of 1 and 2 above.

When using CascadeRowFilter, all of the children records that match the visible parent records will be fitlered.  So let's assume that I put a filter like this on my parentBO:

MyParentBO.Filter = "PrimaryKey = 1 OR PrimaryKey = 3"

In this example, the following child records would be visible:

 

PrimaryKeyParentForeignKeyOrderTotal
11$15.00
21$20.00
43$10.00

GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Threaded View
Threaded View
Malcon M. Mikami - 17 Years Ago
Ivan George Borges - 17 Years Ago
Malcon M. Mikami - 17 Years Ago
Malcon M. Mikami - 17 Years Ago
Ivan George Borges - 17 Years Ago
Keith Chisarik - 17 Years Ago
Ivan George Borges - 17 Years Ago
Dustin Taylor - 17 Years Ago
Malcon M. Mikami - 17 Years Ago
Trent L. Taylor - 17 Years Ago
Malcon M. Mikami - 17 Years Ago
Ivan George Borges - 17 Years Ago
Malcon M. Mikami - 17 Years Ago
Ivan George Borges - 17 Years Ago

Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search