changing the block number or records in realtime

[PatrickB101]

Hi, I am very new with oracle. I have this question, is there away to change the block number or records on the fly? I want it to match exactly how many records in the query.

Thanks for your time,
Patrick

 

[carp]

Could you expand on what it is you're asking for? Perhaps an example?

 

[PatrickB101]

This is what the programs does
i have a list of records for the user to pick from
they pick one and displays the records below..
I currently have the number of records displayed property set to 12. Problems some are up to 20.. I know i could just set it to 20 but some are just 2 records long. I need the number or records displayed option under block to change in real time with the number of records queried which is chosen by the user.. i hope that makes since. recap: user picks a set of records they want to edit. it shows the records in the 12 displayed record feilds (currenty). they can edit and save the records.. i want the 12 records displayed to change to the amounted needed.

 

[THoey]

I gather this is an Oracle database, but what are you using to display the data? Terry M. Hoey

 

[PatrickB101]

The program is written in Oracle Developer data base is 8i If that helps.. would a screen shot help any?

 

[Guest_imported]

Please try displaying a screen shot or the exact requirement that you are given for this program.
sokeh

 

[sem]

QUERY_HITS block property returns the number of rows currently fetched. RECORDS_DISPLAYED returns the number of records displayed. But they are both read-only during runtime. Use scrollbars in multirecord block or LOV. You may also play with canvas size, but scrolling is much better. Another decision is to use T-list resizing it during runtime, but it may depend on screen resolution and font size and is hardly portable across different platforms.

BTW this is the wrong forum. Try Oracleeveloper or Oracle:Enterprize Developer Suit

 

[PatrickB101]

OK I got some screen shots. Thanks sem for the help. So are you saying that Records_Displayed cannot be changed at all during run time? You can see what I am talking about in prog3 and prog4. In prog4 there are 26 records. I want to make the records display (the table layout of the data) adjust to the amount of query hits. I don't think it looks good only showing 2 records and there are 12 box's either.

http://www.angelfire.com/ky/holyh2o/prog1.jpg

http://www.angelfire.com/ky/holyh2o/prog2.jpg

http://www.angelfire.com/ky/holyh2o/prog3.jpg

http://www.angelfire.com/ky/holyh2o/prog4.jpg

thanks for the time