| Clear a block for enter query mode (merged 5) [message #539459] |
Mon, 16 January 2012 03:24  |
 |
bijuandenb
Messages: 3
Registered: January 2012
|
Junior Member |
|
|
Dear, I am a started in this forum and a novice in the Or.forms.
I am using Forms 6i,Oracle 10g.
In a form I created, I have 3 blocks, first is a toolbar type with buttons to save, exit etc., other two are one master and detail data block.
Pls someone tell me how to get the default Oracle toolbar with the buttons, save, delete etc. I dont get in my form.
When the cursor is inside the detail block and then I click on an EnterQuery button in the first block, how do I clear the detail block, using the on btn press code.
What happens when I click the Enter Query button, is that the cursor and current block becomes the button block and when I run the command ENTER_QUERY, no use.
I need to set the block in which the cursor is to be cleared for query, whether it is master or detail, by pressing the button on the first block.
Can someone pls help me.
Thanks
Biju
|
|
|
|
|
|
| Re: Clear a block for enter query mode (merged 5) [message #539472 is a reply to message #539468] |
Mon, 16 January 2012 04:33  |
 |
Tomcrzy
Messages: 101
Registered: December 2011
Location: Chennai,India
|
Senior Member |
|
|
Hi bijuandenb,
"Pls someone tell me how to get the default Oracle toolbar with the buttons, save, delete etc."
In my knowledge i don't know there is something exists in forms like you mentioned above.may be using some procedures..
if you want to clear the block while entering the master details use execute_query,show_view,go_block,clear_block.
may be , i don't know! is this you really meant for?.
[Updated on: Mon, 16 January 2012 04:34] Report message to a moderator |
|
|
|
| Re: Clear a block for enter query mode (merged 5) [message #539501 is a reply to message #539472] |
Mon, 16 January 2012 10:37 |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
bijuandenbhow to get the default Oracle toolbar with the buttons
Open form's Property Palette window and put "DEFAULT&SMARTBAR" into the Menu Module property.
Quote:I need to set the block in which the cursor is to be cleared for query, whether it is master or detail, by pressing the button on the first block.
Does it mean that EVERY block has its own toolbar (or, at least querying buttons)? If so, that's kind of strange.
Anyway, entering query mode in any block will ... well, put that (current) block into a query mode (clear its contents and wait for you to enter some values and, finally, execute query). So, if you are currently in a detail block, ENTER QUERY will put DETAIL block into a query mode. If there is a value in a master block, you'll be able to query only that master record's detail records.
I'm afraid I don't understand the question.
Cookiemonster
I don't know how having never had to set it up
 Too much editing?
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
