I am new in this forum by what I ask for the V / Understanding. . . . I make self-employed but sometimes I have small developments in various languages, especially forms Builder Oracle.
I looked everywhere and I did not find an answer to my problem that is the following:
in the forms Builder Oracle 9i, I have a form with 2 blocks Master-Detail that works beautifully. The blocks are both basetable being the relationship of type join non-isolated and I intend to list the lines based on a condition applied to the child-child. Example, the Master Block is from football clubs and Detail block is from each club's results. What I want is to present not all lines, but only the lines in which the teams have marked more than 5 goals.
I tried to do without success this way:
set_block_property('block_clubes', default_where, 'clube_ID in (select clube_id from block_resultados where num_golos>5)');
Someone has a good tip? Thanks from now on. . .