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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

2 data blocks - same data source - best way?

447756Jul 27 2005 — edited Jul 28 2005
hi all,

before i post my question i'd like to tell u that i'm very new to oracle and forms (10 days or so) so please excuse me for any dummy thoughts ;)

what i want to do is having a data block (just for viewing purposes) that will look like a list where the user can select a record at a time. When the user make his selection there should be another data block (with more fields from the SAME table) where he could see AND change the details of the selected record. The two data blocks will be based on the same table of course but the second will have to have all the details (fields) and only one record at a time while the first will be much briefer and will have many records shown at a time as it will serve record selection purposes. i think this is a usual case for database based programs and i hope i was clear in what i wanted to say so u understand it.

what i thought is do the first data block with the brief select but all the rows of the table and every time user selects a record i would go and change the select data source of the second to hold only the record i want with all the fields. this means that every time the user clicks on a row, there will be a separate transaction with the db to execute the query and get the specific record but with all the fields.

Is my thought good or am i missing something? Is there a more efficient way for this case? Cause this will run over the web and i need it to be fast..

hope i was brief and clear
thanks in advance,

teo
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 25 2005
Added on Jul 27 2005
9 comments
1,600 views