Oracle Forms (MOSC)

MOSC Banner

Master-Detail Foms,Update after Execute-Query

edited Mar 31, 2010 1:48AM in Oracle Forms (MOSC) 13 commentsAnswered
Hi All,

I have a master-detail form.These are the below issues.

1) When I want to display data in both master and detail form, I have a query button and I have written a trigger inside it. The trigger has a the below code.

IF :SYSTEM.RECORD_STATUS IN ('INSERT','CHANGED','QUERY') THEN
CLEAR_FORM(No_Validate);
ENTER_QUERY;
ELSIF :SYSTEM.RECORD_STATUS IN ('NEW') THEN
EXECUTE_QUERY;
END IF;

And this code works fine,But when I try to update the data fetched from the Execute Query.My Update statment does not work.Not only my Update statement,None of my DML statements seems to work.

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