oracle Forms

Hi i have a requirement in Forms as follows.

1) a form will have 3 blocks(3 tables)
 first one is client where I search for client and the corrosponding enrollments should be displayes
2) second one is Enrollments(enrolID is the main key and can have multple for one client and I am able to get that in my form (working fine)
3) third one is also multi line and programs and the Program ID is the unique key and enrol iD is the foreign key.

for eg.

client ID (first block)
10
enrolment (second block)

client iD    enrol ID
10               1
10               2
10               3

third block

EnrolID             Prog ID
1                            1001
1                             1002
2                              1003
2                               1004
3                              1005
3                               1006
i wrote on when button pressed(retrieve information)
code

 :PARAMETER.PNIN_CLIENT_ID := :block1.CIS_CLIENT_ID;

    GO_BLOCK( 'block1' );
    SET_BLOCK_PROPERTY( 'block1', DEFAULT_WHERE,
        'WHERE CLIENT_ID IN ' ||(:PARAMETER.PNIN_CLIENT_ID));
    EXECUTE_QUERY;

    GO_BLOCK( 'block2' );
          SET_BLOCK_PROPERTY( 'block2', DEFAULT_WHERE,
        'WHERE CLIENT_ID = ' || :PARAMETER.PNIN_CLIENT_ID);
    EXECUTE_QUERY;
   
    GO_BLOCK( 'block3' );
          SET_BLOCK_PROPERTY( 'block3', DEFAULT_WHERE,
        'WHERE ENROl_ID = ' || :block2.ENROl_ID);
    EXECUTE_QUERY;

i am able to get only for the first row in second block but other rows are not showing up. as I move my cursor to next record it should show the next record programs. can you please advise. thanks.
EnrolID             Prog ID
1                            1001
1                             1002
but not for others enrolments.
Sarma VadlamaniprogrammeranalystAsked:
Who is Participating?
 
flow01Commented:
If you don't know how to code it,  still use the wizard and take a peek in the fmb : the code will be there.  (relationships between the blocks, when-new-records-triggers on a master block that trigger the execute_query of the detail-block and the same construction for the second-relationship).
I used designer about 20 years back to generate forms and was not pleased with it.  I know since then it improved, but I don't use it so I can't give you advise in using designer todo this.
0
 
flow01Commented:
If you use the wizard to create the blocks you  get -  when creating the second block -  the question if you want to create a relation ship too: use it to create the relationship between client en Enrollments and use the same method to create a relationship between enrollments and programs,  
Oracle forms will create the necessary triggers to synchronise the child blocks with the mastberblocks.
If you don't want to recreate your form do those actions in a new form,  look what oracle generates an copy what you need.  
But if you don't have much experience with forms : use the wizard.

the where clause on (:PARAMETER.PNIN_CLIENT_ID))  can be defined in the block-properties of the form (if you always
want to use it)
If you only want to use it when pressing the button consider using the ONETIME_WHERE  block-property
0
 
Sarma VadlamaniprogrammeranalystAuthor Commented:
but I am not using forms to generate but using designer to generate the forms.please advise.
0
 
Sarma VadlamaniprogrammeranalystAuthor Commented:
plesae find the screenshot. i am getting for first record but when trying to navigate to next row
not showing corrosponding records. code i am writing in designer and using the same to generate forms.screenshot.doc
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.