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.
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.
I have a form in which there are three blocks A,B and C. When I press F7, the form enters Enter-Query Mode and all blocks clear except block A's one item. Say, Block A has 5 items, Item1, Item2,.. Item5. When I enter Enter-Query mode, Item2 of block A is not cleared and rest all are cleared.
I have a form with multiple tabs, each tab showing one data block. Many of the blocks are standard in enter-query mode. I want to allow the users to navigate through the tabs while the blocks are in enter-query mode.how can i do this?
I currently have a form in which a master block populates a detail block. when the master is populated the cursor automatically goes to the detail block and sets it to enter query mode (due to the face that there are multiple details but the user may only view one at a time). To select the appropriate detail the user may select the detail from a LOV which is activated by clicking a button. once the detail has been selected and the query executed there is no real need for the LOV as the user can now edit/delete the detail. Also when adding a new detail there would be no need for the LOV as the presence of it would only confuse users. So basically the only time the LOV is usefull is during query mode to query the detail the user wants to edit/delete.
I have to create a form and i have to use trigger when-validate-item in enter-query mode . I have read trigger when-validate-item can not use Enter Query Mode . Is there any way to do this when i enter-query?
Is it possible to get the status of form or block every time? I mean if user presses Enter query key, it should display some status and if user presses execute query key then it should reflect some status. If user update any then it should reflect.
I am working on form builder 6i.I have FIND widnows and MAIN window.
FIND Window: contains field1 and field2, FIND Button.
block A: Multi record data block on table t1. It contains field1,field2,field3. block B: non datablock, it contains field4, field5.
If i enter something and click FIND button, it will populate data in Block A.If i put the cursor in any record in block A, and after that put the cursor in Block B, it will populate block B related to Block A record.For this, In Block A--> post record(block level) trigger, i am capturing values in variables.
In Block B--> When-New-Block-instance(Block Level)
select field3, field 4 from t2 where t1=:global.f1 and t2=:global.f2;
and populating data in block B.It's working fine.
REQUIREMENT: If i click the FIND second time, in Block B--> it's retaining previous value. I want to clear the block B once i click the FIND button. I tried to write in POST-BLOCK (Block B-->block level)
CLEAR_BLOCK('NO_VALIDATE');
But it's not working.In which trigger i have to write code to clear block.
I am working in form 6i, EBS 11i. I have below requirement to achieve.
I have header data block A, line control block B. My requirement is, i know that in master detail block, if i press F11 in header block, it will clear the line block, like this, in my case if i press F11 in header data block A, i want to clear the line block B. Is there any way we can achieve this.
First i have entered a record in the control block.
Then i navigate to header block,entered the first record for Header Block.
Then i navigate to Detail block,entered the first record for detail Block.
then i again navigate to Header Block..
Now the Problem comes....As i am Trying to enter second record for header block,the pop up comes as "Do you want to save the changes".
Condition 1:i dont want that message to appear for every header record i enter.
Condition 2:For every header record i enter,Corresponding detail record would have been entered.i want that detail records to be retained if i am clicking that header record as i have already created relationship for both header block and detail block.
Data block 1- master_blk : For date/customer of sale invoice Data block 2- detail_blk1 (detail of the master block - For products and qty) Data block 3- detail_blk2 (detail of DETAIL_BLK1 For entering serial numbers of products)
My requirement is that whatever quantity user enter in data block 2 against each product he must enter equal number of serial numbers of that product in data block 3.
For this I have created on item (cnt_iteml : to count product's serial numbers in block3 ) in data block 2, and on summary item (t_serial_no ) in block3.
Whenever user changes in quantity, cnt_iteml: item is populated with t_serial_no in block3 of that product by following trigger on quantity column.
Following trigger is written on block level at data block-3 to populate cnt_iteml with t_serial_no. PRE-RECORD
IF GET_BLOCK_PROPERTY('SERIAL_NUMBERS',STATUS) IN ('CHANGED') THEN :stock_transactions.cnt_itl:=:serial_numbers.t_serial_no; END IF;
Above triggers are fulfilling my requirement except following condition.
If user after entering serial numbers in block 3 and without saving goes back to block2 and try to navigate to another record he gets a message asking him to save changes by forms. At this time if user presses no then cnt_itl item is not been populated with t_serial_no item's value.
What I want in above condition is that if user was inserting new record cnt_it item should be populated with 0, so that he shouldn't be able to save this record. And If he was updating then cnt_itl item should be populated with actual no of records in database against that product.
I have a query form where I am attempting to add radio buttons for the user to specify if they want to see Active, Expired, or Both vendors. The existing form is a multirow database block and a single-row detail database block. Users query in the multirow block. I created a QRY_CONTROL non-database block with the radio group and a couple other variables. When they select a radio button, the WHEN-RADIO-CHANGED changes the default block's where clause.
My problem is that the radio buttons cannot be changed in ENTER-QUERY mode. If they cancel the query, the buttons work as expected. I put in a couple messages and the trigger isn't even firing, so I ruled out a code problem I think.I checked to make sure that the group properties are Enabled=true, mouse_navigable=true, query_allowed=true.
How do I close a window in query mode?My form has a button "Populate from Charge Master" which opens a window containing a List Item (Department Names) and 2 buttons,
1. "Select the Dept" and 2. "Cancel"
The WHEN-BUTTON-PRESSED trigger code for "Populate from Charge Master" button is as follows:
begin SHOW_WINDOW('WINDOW_POP_FROM_CHARGE_MASTER'); go_block('bl_med_dep'); enter_query; end;
BEGIN hide_window('WINDOW_POP_FROM_CHARGE_MASTER'); show_window('WINDOW1'); GO_BLOCK('BL_CHARGE_COMPANY'); END;
Here WINDOW1 is the main window and WINDOW_POP_FROM_CHARGE_MASTER is the window which must be closed when "Cancel" button is pressed.
When I remove "enter_query" statement in "populate from charge master" trigger code, I am not able to select any of the departments from the list. and If I have that statement, I am not able to hide/close the window.
I have created a custom form. I have field called Order No. When i query on Order no.. i should be able to pick order no as well as other fields related to it. how do i acheive this functionality. I mean the f11 and ctrl f11 querying functionality.
Am developing a custom form. I have a block with 5 Items and one button(SUBMIT). When I go in query mode (F11), SUBMIT button to be disabled. How do i achieve this.
At once when I open the form when I press F11 it is not entering query mode. But if I type something in the text box placed in the form then I press F11 means it is asking "Do you want save the changes you have made?" if I press yes or no, no matter it is going for query mode. How to go to query mode without typing something in it?
How can i sort data in the execute Query mode during runtime,i have a columns which has number, char and date field.
This below data is fetched in execute query from a table; x1 x2 x3 1343 adfa 11/14/2012 1353 adfa 11/11/2012 1333 adfa 11/10/2012 1333 adfa 11/12/2012 1353 adfa 11/09/2012
I have one form, when i press f7 , it says the "The function has no meaning in this context" , how to make it query enabled block.Actually i am going to that block using when button pressed and execute_query.
I have a Master block and a Detail Block. They are related using two columns, Document_ID and Page_no. I want to display all the records in master table with corresponding detail records beside them in single line. i.e., as shown below:
MasterItem1 DetailItem1 DetailItem2 DetailItem3
I created the relation between them and executed query. When I execute query in the form, I can find that all the Master Items are displayed in vertical records, but i can only see one record of detail fields. They are displayed as shown below:
Version information: Forms [32 Bit] Version 10.1.2.3.0 (Production) Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
When an user enters a value in a field of a Screen, I want to query up the next screen records based on that user input value in the previous screen.The previous screen is based on a control block i.e.
In a master and detail relation ship block..When a cursor is placed in the details and enter some thing and giving back space..once value is cleared a empty record is saved in the database with the header values , but in details customer didn't enter anything.
how to clear the detail record in pre insert or when validation ?
I have a problem in my form. In my form there are 4 blocks and in one of the block i have a button. In which i put a code same as below:
BEGIN IF NAME_IN('SYSTEM.FORM_STATUS') = 'CHANGED' THEN CLEAR_FORM(NO_VALIDATE); END IF; PROCEDURE ABC; END;
So as per code i want to clear all the changes in form for current session and want to call the procedure ABC after that. But it is not calling the procedure ABC. And what would i do to perform the same?
I have three database fields on my form , field_1 , field_2 and field_3 , user will enter the data in field_1 , and sometime he may not enter in field_2 ,
I want to bring the value of field_1 as it is into field_3 if he does not enter anything in field_2, if he enters the data in field_2 , then field_1 will get concatenated with field_2 and gets copied into field_3.Is there a way to do this automatically at form level using a trigger when-validate-item.In short this should be done after user presses the enter key on field_2.
create table ot_Sale_code_head ( sale_code varchar2(12),code1 varchar2(6),code2 varchar(6),code3 varchar2(12)); insert into ot_Sale_code_head ('A','01.01',NULL,NULL); --inserted record in form will be 'A','01.01',NULL,'01.01' insert into ot_Sale_code_head ('B','01.01','PS-P',NULL); --inserted record in form will be 'B','01.01','PS-P','01.01.PS-P'
I have 2 text fields as search criteria and a push button to search. When the user enter any on first field (or in any text field) and press ENTER key, I want to execute the search.
I tried the key-next-item trigger, but it's firing when I press TAB key.
I developed a custom Form using Form Builder 6i. This Form has selection criteria (data to be entered in a couple of fields) and a "Find" Button, which queries the data (based on the selection criteria) and populates all fields on the Form.
This Form has a couple of "Required" fields in its search criteria section. When data is not populated in any of the Required fields and "Find" button is clicked upon, Form raises an exception and pops up a message indicating the user 'to enter data in mandatory fields'. However, this message keeps popping up and would not stop.
So, I'm not able to proceed with querying data on my custom Form. I had to kill the session and reconnect to front end to overcome this issue.
i have multi data block filed. and checkbox field which based on control block...My task is when i check checkbox only one field should enabled and my mouse goes to that field
My item field based on data block and checkbox based on control block,while i checked chkbox1 , only item31 on that current record should be enabled and i changed value only on that field
when i checked chkbox1 , my cursor goes to item31...not item32