Searching Master/Detail Blocks 1

[Velena]

Hi all,

I would like to have master and detail blocks in Oracle Forms 9i and do query by some fields in master and detail blocks. I have control block which store search variables. What is the best way for such filtering?

Regards,
Velena

 

[lewisp]

Try using the [tt]Set_Block_Property(<block>,ONETIME_WHERE);[/tt] built-in.

 

[Velena]

Thanks a lot,lewisp, it works.
Setting WHERE clause property for master block seems solving the problem as well.

Velena