Home » Developer & Programmer » Forms » Canvas scroll bars.. (Oracle 10g designer forms)
Canvas scroll bars.. [message #389834] Tue, 03 March 2009 13:57 Go to next message
jaki09
Messages: 11
Registered: March 2009
Junior Member
Hi All,

Please help me out on this issue.

I am developing one form in oracle 10G. This form contains one table having these fields. Table name: XXCFI_NEW_TABLE
Country_name,Country_code,Registration_number,Rep1,Rep2,Rep3,
Rep4,Rep5,Rep6.

I have developed the form with two canvases and selected tabular with 10 records display.
First canvas is content and having country_name,country_code,Registration_number
Second canvas is stacked canvas having Rep1,Rep2,Rep3,
Rep4,Rep5,Rep6.

My question is how to show scrollbar on two canvases.
when I will query for example US has 5 records(no need scroll bar), CAN has 15 records. so when i will query CAN the two canvas has to show scroll bar to show all 15 records.

Please help me on this issue.

Thanks
Jaki

[EDITED by LF: fixed topic title typo; the original was "scorll"]

[Updated on: Sat, 21 March 2009 15:09] by Moderator

Report message to a moderator

Re: Canvas scorll bars.. [message #389838 is a reply to message #389834] Tue, 03 March 2009 14:26 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
As all items belong to the same table and data block, your "problem" is really not a problem: you either display a scrollbar or not - most probably you will display it. It doesn't depend on number of records per country; for US, scrollbar will have no function; for CAN it will make possible to scroll up and down. Layout might look like this (from left to right): items that belong to content canvas - stacked canvas with its items - scrollbar on the content canvas.
Re: Canvas scorll bars.. [message #389856 is a reply to message #389838] Tue, 03 March 2009 16:32 Go to previous messageGo to next message
jaki09
Messages: 11
Registered: March 2009
Junior Member
Thanks for reply...

Where I have to change the properties...is it block level or canvas level and which propety i have make it YES.

please let me know.

Thanks
JAKI
Re: Canvas scorll bars.. [message #389886 is a reply to message #389856] Tue, 03 March 2009 23:48 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
"Data block" Property Palette contains a whole section named "Scrollbar".
Re: Canvas scorll bars.. [message #390298 is a reply to message #389886] Thu, 05 March 2009 15:30 Go to previous messageGo to next message
jaki09
Messages: 11
Registered: March 2009
Junior Member
Thanks for your reply.

Its working fine.

One more question. I am getting all the values from backend to front end when i open the form, and also I tried to insert,update some values, but I cannot see FRM:40400 Transaction complete and 1 record saved message at front end bottom of the window.

Can you tell me where i have to set this?

Thanks
JAKI

[Updated on: Thu, 05 March 2009 15:31]

Report message to a moderator

Re: Canvas scorll bars.. [message #390326 is a reply to message #390298] Fri, 06 March 2009 00:00 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
You have to COMMIT (save) changes you've made. By default, Forms will tell you that it has been done .
Re: Canvas scorll bars.. [message #390514 is a reply to message #390326] Fri, 06 March 2009 17:06 Go to previous messageGo to next message
jaki09
Messages: 11
Registered: March 2009
Junior Member
Hi,

I can see from backend its saving records but I cannot see any comments at the bottom of the window like "Transaction completed and 1 record saved" Something is like this.

Please let me know what to do to see these comments by default.

JAKI
Re: Canvas scorll bars.. [message #390569 is a reply to message #390514] Sat, 07 March 2009 10:53 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
As I've said, by default Forms will inform you what it has done. Therefore, you have done "something" that prevents Forms to do that. What? I don't know - revisit all triggers and see whether there's, for example, certain modification of the :SYSTEM.MESSAGE_LEVEL variable, ON-MESSAGE trigger, etc.
Re: Canvas scorll bars.. [message #391066 is a reply to message #390569] Tue, 10 March 2009 19:04 Go to previous messageGo to next message
jaki09
Messages: 11
Registered: March 2009
Junior Member
thanks for your reply.
Re: Canvas scorll bars.. [message #392940 is a reply to message #391066] Thu, 19 March 2009 13:37 Go to previous messageGo to next message
jaki09
Messages: 11
Registered: March 2009
Junior Member
Hi,

One quick question please...

In my form there are three buttons...say Button1, Button2 & Button3.

when I click on Button1 its opening concerned block1.

If I click on Button2 then it has to open block2..its working fine but when i close this block its opening block1 also.

and If I click on Button3 then it has to open block3..its working fine but when i close I can see block2 and block1 also..

Can you suggest me what to do.

Thanks in Advance
Jaki
Re: Canvas scorll bars.. [message #392944 is a reply to message #389834] Thu, 19 March 2009 13:54 Go to previous messageGo to next message
cookiemonster
Messages: 12422
Registered: September 2008
Location: Rainy Manchester
Senior Member
You can't open blocks - it doesn't mean anything.
You can open forms and you can open windows.
You can also display/hide items and canvases.

I assume you're trying to do one or more of those, but I'm not sure which.

What is the code in the your buttons?
Re: Canvas scorll bars.. [message #392957 is a reply to message #392944] Thu, 19 March 2009 16:19 Go to previous messageGo to next message
jaki09
Messages: 11
Registered: March 2009
Junior Member
I meant window....not block...

Sorry for confusion...

Give me solution please..

Jaki
Re: Canvas scorll bars.. [message #392962 is a reply to message #392944] Thu, 19 March 2009 17:24 Go to previous messageGo to next message
cookiemonster
Messages: 12422
Registered: September 2008
Location: Rainy Manchester
Senior Member
cookiemonster wrote on Thu, 19 March 2009 18:54

What is the code in the your buttons?

Re: Canvas scorll bars.. [message #393251 is a reply to message #392962] Fri, 20 March 2009 17:16 Go to previous messageGo to next message
jaki09
Messages: 11
Registered: March 2009
Junior Member
Just only

SHOW_WINDOW('Button2');

there is no code other than this in all when button pressed trigger.

Jaki
Re: Canvas scorll bars.. [message #393330 is a reply to message #389834] Sat, 21 March 2009 11:46 Go to previous message
cookiemonster
Messages: 12422
Registered: September 2008
Location: Rainy Manchester
Senior Member
Try hiding the other windows using hide_window.
You might also consider adding go_item commands to send the cursor to the first item in the required block
Previous Topic: Challenging Task for all gurus
Next Topic: import data with double quote string
Goto Forum:
  


Current Time: Sat Dec 10 12:31:08 CST 2016

Total time taken to generate the page: 0.10586 seconds