Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Making a query in Forms 6i to insert values

user626836Mar 9 2011 — edited Mar 21 2011
Hi everyone,
I have 2 Data Blocks in Forms 6i, one is not a Database Data Block and the other one is.
In my first Data Block I have 3 items: teacher_id, grade and class_id
Then, the second Data Block has 10 items where I'm going to be showing 10 rows of data
from my database when the user types the credentials on my 3 items that belongs to my first
Data Block.
Seconda Data Block items:
student_id, student_name,grade_q1,grade_q2,grade_q3
The form should be able to bring just the student_id and the student_name. I have to type then
grade_q1, grade_q2, etc. After that I have to add a buttom to insert all the new information that
I typed to the database.
My question is:
How can I make Forms 6i bring all the data that belongs to that teacher_id, grade and class_id?
After that I would like to insert some data and insert them in the same form.
Can anyone please help me!
This post has been answered by Amatu Allah Neveen Ebrahim on Mar 16 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 18 2011
Added on Mar 9 2011
24 comments
3,844 views