problem with onetime_where and default_where
Hi All,
I have 2 blocks :
- periods
- balances
I have 2 fields in the periods' block and I want that the "balances" block use the values in those feilds to excute the query :
set_block_property('balances', default_where, 'period_name = ''' || :periods.period_name || ''' and segment2 = nvl('''|| :periods.account|| ''',segment2) '' and segment3 = '''|| :periods.ent_ope || ''''); go_block('balances');execute_query;
this code is in a button in the first block.
But the block "Balances" gets all the lines without any "where".
Any ideas ?