Oracle Forms (MOSC)

MOSC Banner

EAV ( Entity-Atribute-Value data model and handling the table in Oracle Forms )

edited Oct 7, 2012 11:11PM in Oracle Forms (MOSC) 2 commentsAnswered
Hello,
Working on smaller business problem that involves EAV model in data model like this:

Survey( Survey# number( 7 )  not null,
              Desc varchar2( 240 ) null,
              DateOfOpening date not null,
              DateOfClose date null                  );

Parameter( Parameter#             varchar2( 40 ) not null,
                   TypeOfValue varchar2( 40 ) not null -- SMALL_INT, SMALL_CHAR, BIGGER_CHAR, BIGGER_MONEY
                  
                  );

SurveyParameters( Survey#, Parameter#, Value_SMall_Int, Value_Small_Char, Values_Bigger_Char, Value Bigger_Money )

the table SurveyParameters would demand intensive generic controles in navigation and validation.
Only one type of value is relevant ( table Parameter is driving the decision  ).

So wonder about the real state of the canvas and navigational and item validation logic that would handle in multi-record master-detail structure for

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