OraFAQ Forum: Forms » Vertical scrollbar not showing all the records when I scroll down.

Home » Developer & Programmer » Forms » Vertical scrollbar not showing all the records when I scroll down. (Oracle 10g Forms, Windows OS)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Vertical scrollbar not showing all the records when I scroll down. [message #522950]

Wed, 14 September 2011 13:44

piyarustagi
Messages: 38
Registered: January 2011

Member

Vertical scrollbar not showing all the records when I scroll down.

Using Oracle forms 10g , operating system windows

I have two fields with number of items dispayed = 15.
I have a vertical scroll bar with them. There are 34 records in the table but the scrollbar only shows 15 records.

Attaching the form

Attachment: TEST.fmb
(Size: 116.00KB, Downloaded 1238 times)

Report message to a moderator

Re: Vertical scrollbar not showing all the records when I scroll down. [message #522953 is a reply to message #522950]

Wed, 14 September 2011 15:09

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

Scrollbars do not show records. They allow you to scroll through the records in a block, so I am not sure what you are saying or asking.

So here is my guess/answer.

15 records are showing in a multi-record block. Use the scrollbar to scroll down, either by dragging it down, clicking on an area below the solid bar, or clicking the down arrow at the bottom.

If you are saying dragging the scrollbar down to the bottom and it does not go to the last record, it will not. It will only move down the number of record that will fit in it's buffers.

Report message to a moderator

Re: Vertical scrollbar not showing all the records when I scroll down. [message #522954 is a reply to message #522953]

Wed, 14 September 2011 15:11

piyarustagi
Messages: 38
Registered: January 2011

Member

yes I wanted to say that only.
that when I press that arrow button or I drag the scroll bar down..It doesn't show all the records..
It only shows 15 records..
how can I see all the records?

Report message to a moderator

Re: Vertical scrollbar not showing all the records when I scroll down. [message #522955 is a reply to message #522953]

Wed, 14 September 2011 15:16

piyarustagi
Messages: 38
Registered: January 2011

Member

Also, If I select any record, and then press down arrow key, then I'm able to go to the last record.

Report message to a moderator

Re: Vertical scrollbar not showing all the records when I scroll down. [message #523070 is a reply to message #522954]

Thu, 15 September 2011 08:22

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

piyarustagi wrote on Wed, 14 September 2011 16:11

yes I wanted to say that only.
that when I press that arrow button or I drag the scroll bar down..It doesn't show all the records..
It only shows 15 records..
how can I see all the records?

You are lacking in your explanation. If you have a multi-record block with 15 rows showing, then all you can see is 15 records at a time.

Maybe you can describe in grammatically correct english what you see and what you want. I cannot understand what you see or what you want.

Report message to a moderator

Re: Vertical scrollbar not showing all the records when I scroll down. [message #523071 is a reply to message #522955]

Thu, 15 September 2011 08:24

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

piyarustagi wrote on Wed, 14 September 2011 16:16

Also, If I select any record, and then press down arrow key, then I'm able to go to the last record.

Highly unlikely. If you are on any record and you press the down arrow key, you will move down ONE record unless there is fancy code in your form.

Report message to a moderator

Re: Vertical scrollbar not showing all the records when I scroll down. [message #523073 is a reply to message #523071]

Thu, 15 September 2011 08:28

piyarustagi
Messages: 38
Registered: January 2011

Member

Yes by pressing the down arrow key again and again I'm able to reach at the last record but the scrollbar doesn't move down.

Quote:

15 records are showing in a multi-record block. Use the scrollbar to scroll down, either by dragging it down, clicking on an area below the solid bar, or clicking the down arrow at the bottom.

If you are saying dragging the scrollbar down to the bottom and it does not go to the last record, it will not. It will only move down the number of record that will fit in it's buffers.

Yes I'm doing the same thing.

Report message to a moderator

Re: Vertical scrollbar not showing all the records when I scroll down. [message #523076 is a reply to message #523073]

Thu, 15 September 2011 08:38

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

piyarustagi wrote on Thu, 15 September 2011 09:28

Quote:
15 records are showing in a multi-record block. Use the scrollbar to scroll down, either by dragging it down, clicking on an area below the solid bar, or clicking the down arrow at the bottom.

If you are saying dragging the scrollbar down to the bottom and it does not go to the last record, it will not. It will only move down the number of record that will fit in it's buffers.

Yes I'm doing the same thing.

What is this a response to?

I still do not understand what you are doing.

If your form only returns 15 records and your multi-record block displays 15 records, then the scrollbar will not do anything.

You say your table has 34 records, but maybe your form is only querying 15 record.

Or you completely ignored that I told you when you drag a scrollbar to the bottom, it WILL NOT go to the last record, but only scroll down the number of records that it can buffer.

You are going to have to show screen shots at every step because I for one do not understand what you are doing or saying.

[Updated on: Thu, 15 September 2011 08:41]

Report message to a moderator

Re: Vertical scrollbar not showing all the records when I scroll down. [message #523080 is a reply to message #523076]

Thu, 15 September 2011 08:48

piyarustagi
Messages: 38
Registered: January 2011

Member

SELECT count(*) FROM WORK_CATEGORY

Result = 35

/forum/fa/9358/0/

/forum/fa/9358/0/

See that it's only showing 20 out of 35 records even if I drag the scollbar down.

Attachment: 2.JPG
(Size: 117.89KB, Downloaded 4360 times)

Report message to a moderator

Re: Vertical scrollbar not showing all the records when I scroll down. [message #523082 is a reply to message #523076]

Thu, 15 September 2011 08:53

cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester

Senior Member

What are the following data block properties set to:
Query Array Size
Number of records buffered
Number of records displayed
query all records

Report message to a moderator

Re: Vertical scrollbar not showing all the records when I scroll down. [message #523083 is a reply to message #523082]

Thu, 15 September 2011 08:55

piyarustagi
Messages: 38
Registered: January 2011

Member

Query Array Size - 0
Number of records buffered - 0
Number of records displayed - 60
query all records - No

Even if I change these properties, nothing happens.

Report message to a moderator

Re: Vertical scrollbar not showing all the records when I scroll down. [message #523099 is a reply to message #523083]

Thu, 15 September 2011 09:51

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Try to recompile the form (Ctrl + Shift + K).

If it still doesn't work, try to remove a scrollbar, recompile the form, run it - scrollbar shouldn't be there. Then create a scrollbar once again, recompile, run. What happens?

Report message to a moderator

Re: Vertical scrollbar not showing all the records when I scroll down. [message #523101 is a reply to message #523099]

Thu, 15 September 2011 09:57

piyarustagi
Messages: 38
Registered: January 2011

Member

Scroll bar can't be deleted..

Block's property 'SHOW Scroll Bar' can be changed from yes to no.

I did that too.. nothing happened..
Thanks

[Updated on: Thu, 15 September 2011 09:58]

Report message to a moderator

Re: Vertical scrollbar not showing all the records when I scroll down. [message #523122 is a reply to message #523101]

Thu, 15 September 2011 13:23

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

I am making another guess here, based on color highlighting.

Are your buttons in a separate block? Is the scrollbar associated with that block instead of the data block?

Report message to a moderator

Re: Vertical scrollbar not showing all the records when I scroll down. [message #523125 is a reply to message #523122]

Thu, 15 September 2011 13:27

piyarustagi
Messages: 38
Registered: January 2011

Member

No, there is only one block.
I have attached my form in my question above - TEST.fmb
.

[Updated on: Thu, 15 September 2011 13:28]

Report message to a moderator

Re: Vertical scrollbar not showing all the records when I scroll down. [message #523140 is a reply to message #523122]

Thu, 15 September 2011 14:48

piyarustagi
Messages: 38
Registered: January 2011

Member

Solved the issue..

Changed block property..number of records displayed from 60 to 20

Report message to a moderator

Re: Vertical scrollbar not showing all the records when I scroll down. [message #523160 is a reply to message #523140]

Thu, 15 September 2011 15:41

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

That's what your screenshot suggests - number of displayed records already was 20 (so what property did you modify?).

Report message to a moderator

Re: Vertical scrollbar not showing all the records when I scroll down. [message #523254 is a reply to message #523160]

Fri, 16 September 2011 07:29

piyarustagi
Messages: 38
Registered: January 2011

Member

The block property (not the item's property)

Report message to a moderator

Re: Vertical scrollbar not showing all the records when I scroll down. [message #523259 is a reply to message #523254]

Fri, 16 September 2011 07:55

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

That's what I said. There are 20 records displayed in a block on your screenshot (not 60 records).

Report message to a moderator

Re: Vertical scrollbar not showing all the records when I scroll down. [message #523260 is a reply to message #523259]

Fri, 16 September 2011 08:02

piyarustagi
Messages: 38
Registered: January 2011

Member

Before:
Number of Items displayed propery of item WORK_CATEGORY = 20
Number of Items displayed propery of item JOB_TYPE = 20
Number of Records displayed propery of block WORK_CATEGORY = 60

Now I changed it to:

Number of Items displayed propery of item WORK_CATEGORY = 20
Number of Items displayed propery of item JOB_TYPE = 20
Number of Records displayed propery of block WORK_CATEGORY = 20

Hope you understood now.

Report message to a moderator

Re: Vertical scrollbar not showing all the records when I scroll down. [message #523264 is a reply to message #523259]

Fri, 16 September 2011 08:12

piyarustagi
Messages: 38
Registered: January 2011

Member

I guess the reason is that...
when the block property is 'Number of records displayed = 60' and my table had only 35 records.
Scrollbar doesn't go down because it thinks that all the records have been fetched.
But when I changed the property to 20, scrollbar goes down to fetch more records.

Sorry, I know I'm not so good in English...but I hope I made my point.

Report message to a moderator

Re: Vertical scrollbar not showing all the records when I scroll down. [message #523265 is a reply to message #523264]

Fri, 16 September 2011 08:13

cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester

Senior Member

I'd set that property to 15 - same as number of items displayed.

Report message to a moderator

Re: Vertical scrollbar not showing all the records when I scroll down. [message #523267 is a reply to message #523265]

Fri, 16 September 2011 08:16

cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester

Senior Member

In fact set that to 15 then change the number of items displayed property of job_Type and work_category to 0.

Report message to a moderator

Previous Topic:	WHEN-VALIDATE-ITEM trigger raise unhandled exception ORA-01422
Next Topic:	Oracle Forms & Reports 10g with Oracle 11g database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 09 06:32:23 CST 2025