Oracle Forms (MOSC)

MOSC Banner

problem with onetime_where and default_where

edited Feb 22, 2019 6:35AM in Oracle Forms (MOSC) 6 commentsAnswered ✓

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 ?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center