By Malcon M. Mikami - 11/10/2008
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.
|
By Ivan George Borges - 11/10/2008
Difícil descobrir assim, Malcon, sem ter um exemplo na mão.Mas olhandos suas imagens, a única coisa que dá para notar é que em uma você está parado na linha de GPP_PKID = 5, e então o GPP_GPS_PKCODIGO = 454, enquanto que na outra você está no GPP_PKID = 4, e o GPP_GPS_PKCODIGO = 123, o qual pode ser que não tenha nenhum relacionamento na sua tabela GPS.
|
By Malcon M. Mikami - 11/10/2008
Ivan, em anexo o projeto e os scripts de criacao de tabelas.
|
By Malcon M. Mikami - 11/10/2008
Ivan. Me corrija se eu estiver errado.Nas imagens tenho 3 grids. O superior o Pessoa, O do meu PessoaProduto e o inferior Produto. Se faço um ChildAutoFilterOption = MatchCurrentRow no Bo do grid do meio, que possuie 2 registro, o grid inferior(filho do pessoaproduto) nao deveria tbm aparecer 2 registros?
|
By Ivan George Borges - 11/10/2008
Não, deveria aparecer somente o Produto relacionado ao seu PessoaProduto.
|
By Keith Chisarik - 11/10/2008
Ivan,Do you know of a Portugese to English translator, perhaps a website? I read most of the posts on the forums just to have them in the back of my mind when I run into an issue or task. I wish I could read some of your answers
|
By Dustin Taylor - 11/10/2008
translate.google.com is what we usually resort to when Ivan isn't around (which, thank the lord, isn't all that often  )
|
By Malcon M. Mikami - 11/10/2008
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?
|
By Trent L. Taylor - 11/11/2008
The MatchCurrent row will only filter out records on the child BO that match the parent relationship. For example,Parent BO | PrimaryKey | Name | | 1 | ABC Vending | | 2 | XYZ Autos | | 3 | Zenith Auto Sales |
Child BO
| PrimaryKey | ParentForeignKey | OrderTotal | | 1 | 1 | $15.00 | | 2 | 1 | $20.00 | | 3 | 2 | $40.00 | | 4 | 3 | $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: | PrimaryKey | ParentForeignKey | OrderTotal | | 1 | 1 | $15.00 | | 2 | 1 | $20.00 | | 4 | 3 | $10.00 |
|
By Malcon M. Mikami - 11/11/2008
Hi Trent, thanks for the prompt reply.
I have the following situation: Person (PrimaryBO) PrimaryKey Name 1 Malcon 2 Trent 3 Ivan PersonProduct(RelationBO) PersonForeingKey ProductForengKey 1 1 1 2 2 1 2 3 2 4 3 1 Product(ChildBO) PrimaryKey Details 1 Hard-Disk 2 CPU 3 LCD 4 Case When I select a line of Person, it will filter every record in PersonProduct, I would like to automatically filter out all visible record in Products based on PersonProduts My relationship this way: Person ---(MatchCurrentRow)----PersonProduct ----(CascadeRowFilter)----Product In short, when I filter a Person would like to see all the details of the products this person. |
By Ivan George Borges - 11/11/2008
Keith Chisarik (11/10/2008)
Ivan, Do you know of a Portugese to English translator, perhaps a website? I read most of the posts on the forums just to have them in the back of my mind when I run into an issue or task. I wish I could read some of your answers Hey Keith. Since you read everything to keep on the back of your mind, it could be a lot better not being able to read my posts! Anyway, if you are brave enough, this is also a good site for translations: http://br.babelfish.yahoo.com/
|
By Ivan George Borges - 11/11/2008
Malcon, have a look at the BusinessLayerLinkManager.Here you find a post about it: http://forum.strataframe.net/FindPost6626.aspx Do a search on the forum and you will find much information on how to use it.
|
By Malcon M. Mikami - 11/11/2008
Problem solved! The "secret" is the businesslayerlinkmanger. In the SF manuals, and the demo applications have not seen examples, nor references to it.
Some of my doubts as to others who read the forum are correctly using the components and exemplify the situation. I think we could have a forum in the area for more video lessons and examples for download.
|
By Ivan George Borges - 11/11/2008
Glad you got it going!  Yeah, the guys are working constantly on more documentation and a Knowledge Base forum. While it is not there yet, count on us all.
|