Oracle Forms (MOSC)

MOSC Banner

using default_where when no value is returned

edited Sep 20, 2013 3:39AM in Oracle Forms (MOSC) 17 commentsAnswered
Hello all,

Can someone tell me what code I should write for a when button pressed instance if the table used in the following code does not have a record that exist. I am getting a missing expression error. I have some instances where a record will not exist in tabletwo and instead of continuing the form is giving me an error.

set_block_property('tabletwo',default_where,'PERSON_ID = '||chr(39)||:dummy_block.PERSON_ID||chr(39)||' and incident_id = '||:tableone.incident_id);
execute_query;

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