Forms :: Delete_record In Block
Oct 26, 2011I have form same picture under, and i would delete record already checked on tabular when click button DELETE .
View 5 Replies
ADVERTISEMENT
Forms :: Delete_record Not Removing Record From Screen
May 13, 2010I am trying to select a row on the screen and delete a individual row from the screen after hitting the delete button. Whenever i select the row it gets highlighted and also the alert box comes up asking if the record needs to be deleted. When I say yes I notice that the row does not get deleted. The code behind the delete button is as follows
(P.S the block is based of a table and commit_form works and changes are saved to db but not delete_record)
begin
--
Set_Item_Property('my_block.emp_no_copy',current_record_attribute,'va_delete_record');
Set_Item_Property('my_block.emp_LName_copy',current_record_attribute,'va_delete_record');
Set_Item_Property('my_block.emp_FName_copy',current_record_attribute,'va_delete_record');
Set_Item_Property('my_block.last_worked_date_copy',current_record_attribute,'va_delete_record');
--
synchronize;
Set_Alert_Property(alert_id, ALERT_MESSAGE_TEXT, 'Do you want to delete the Highlighted record? {NOT YET}');
[Code]....
Forms :: Multi Data Block And Checkbox Field Based On Control Block
Nov 19, 2010i 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
e.g
item11 item21 item31 chkbox1
item12 item22 item32 chkbox2
Scenario like this :
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
Forms :: Distribute Master Block Total Amount In Detail Block Line Wise
May 5, 2012i have a master detail form, In Master block we have one field cheque amount and in Detail block we have field receiveable amount invoice wise. if company paid us a cheque amount we will enter this amount in Master block field Cheque amount and in detail block there will be invoice wise receivable amounts. i want to distribute the cheque amount in detail block invoice wise for example
Cheque amount in master block = 291
Invoice wise receiveable amount is as follows
Invoice No , receivable amount , Received amount
10, 196 , 0
20 , 95 , 0
30 , 54 , 0
Result should be as follows:
Invoice No , receivable amount , Received amount
10, 196, 196
20 , 95 , 95
30 , 54, 0
Received amount field should be distributed according to the receivable amount when recevied amount = cheque amount then remaining will be 0.
Forms :: How To Read Values In A Multi Record Control Block Using Pre-insert Trigger (block Level)
Jul 24, 2010I have a multi record control block (basically a text item displaying 6 records) where user enters values and I want to process the values using pre-insert trigger.
I want to read value in each record and then do some tasks using a pre-insert trigger before I commit the values. To navigate between the records I was using first_record, next_record, clear_record built-ins but it gives errors like "40737-illegalrestricted procedure next_record in pre-insert trigger".
Forms :: Clear Block Message In Oracle Forms?
Nov 30, 2012I am creating a form with 3 blocks.
Control block,
Header Block,
Detail Block.
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.
Forms :: How To Get Next Value In Master Block
May 3, 2010I created one table with out primary key like well_1 .in that table have have more than 30 columns.
SQL> select uwi,analysis_obs_no,fluid_type,top,base,date_sampled from well_1
2 where uwi ='1000 and base =2871.5;
UWI obs_NO F TOP BASE
---------------- ---- ------ ----- - -----------------------------
1000 1 G 2870.5 2871.5
1000 3 G 2516 2871.5
1000 4 G 2870.5 2871.5
1000 2 G 2870.5 2871.5
1000 6 G 2516 2871.5
1000 5 G 2516 2871.5
1000 7 G 2516 2871.5
1000 1 L 2516 2871.5
1000 2 L 2516 2871.5
7 rows selected.
i did code like this in from in search panel. in taht form i will enter uwi and base values and iwill click search button.then it will display all record values in master block .after taht i will click next button then it will display next values(all values).
i am getting all values (1 G to 7 G values).but iam not getting last 2 records when i click next button (1 L to 2 L values ).
next button
select analysis_obs_no,fluid_type
into :ctrl1.OBS_NO,:ctrl1.fluid_type
from well_gas_anal
where analysis_obs_no =(select min(analysis_obs_no)
from well_gas_anal
[code].....
i tried in SQL*PLUS like this :
select rowid,analysis_obs_no,fluid_type,rownum
2 from well_gas_anal
3 where rowid=(select min(rowid)
4 from well_gas_anal
5 where analysis_obs_no > &a
6 and uwi ='1000' and base =2871.5 )
7 and uwi ='1000' and base =2871.5
8* and fluid_type is not null
SQL> /
Forms :: Call A Block From Another?
Jan 16, 2013I have a main interface that contains 3 buttons (emp, dept, mgr) I want when I click on the button 'emp' interface opens in the main interface(the buttons must remain in the main interface)
see the picture : [URL]
Forms :: Autofill Block
Jul 4, 2011I have 3 tables
1-pr_mst
2-pr_trn
3-hr_mst
Em_code is a common key between theses tables.
on my form table 1 and 2 are the base main tables, due to the relationship, when i enter em_code on table 1 and query it, it shows data on both the table. Its a normal behavior in Master Detail block in forms.
When user enter em_code at form and there is no data found in table 2, obviously it show blank data block related to the table 2 and shows data in table 1 block, now i want an em_code details which stores in the table 3 automatically load in memory and populated in detail block. Is it possible ? and how can i do this.
Forms :: Go Block Not Working?
Sep 18, 2012In a Entry Screen I Require to Check the Value is Changed or not in a Block (A).
If the Value is Changed then Require to done some validation in another block (B) for take the final entry date and their after going to another Block (C), here user require to enter Some data in it.
I am Using the When Timer Expired in the Block (A) for Check the Value and Going Another block, it working till going another after complete the entry Block (C) I have using a Button for move to Main Block (A), but it not going to the consign block and then i put the Message in it, the message is showing, but not going to the block.
Backup & Recovery :: Error / Corrupt Block Relative Dba / 0x01c12a58 (file 7 / Block 76376)
Jan 25, 2011i have an error with block corruption
Error: Corrupt block relative dba: 0x01c12a58 (file 7, block 76376)
What all the ,methods I can go for if we are working on a production environment with out any down time.
I can go for dbms repair package and restore and recover
Forms :: How To Count In List Block
Oct 1, 2011I have a list block of two fields item_name, item_price. User can enter as many item`s as she/he wants. But, before saving the record system should calculate the total and give error if sum is grater then or less than 100.
View 2 Replies View RelatedForms :: Enabling In Detail Block
Jun 22, 2011I have an existing form which i need to customize..In the form in the query block whatever strings we enter..and press the search button..it sets the where clause and use execute query.which populates the detail block which is read only and only 1 column is enabled.
For the Enabled column X I need to enable a button.It has to be done only if the cursor go in the column X
Forms :: Total Field From Another Block
Jun 14, 2013I have 2 blocks named emp,emp1 those are DB's Blocks and empno, ename, sal in EMP block and sal, sum(sal) are in EMP1 block, i set the property for sum is summarized block is: EMP1 and item is SAL, i want display sum(sal), but not display when i click execute query.
View 5 Replies View RelatedForms :: Cannot Navigate To Next Block With Keyboard
Jun 3, 2010I have 2 blocks, MASTER and DETAIL. The navigation style of MASTER is Change Data Block, and its next navigation data block is DETAIL. But despite this, when I tab out of the last item of MASTER, it goes back to the first item of MASTER instead of going to DETAIL.
View 8 Replies View RelatedForms :: How To Restrict Update Of A Block
Feb 22, 2011I want to give update rights of a block to restricted set of people... how can i achieve it???
View 3 Replies View RelatedForms :: Primary Key In Detail Block?
Nov 26, 2010I've a master detail form. I detail form there is no primary key. When it is executed the following error displayed :
FRM-30100: Block must have at least one primary key item.
Block: ASSETS_ISSUE_DTL
Form: FORM_ASSETS_ISSUE_DTL
Forms :: Populate Table From A Block In 10g?
Dec 3, 2010TABLE_FROM_BLOCK built-in Package is working in Forms 6i but not in Forms 10g. is there any other built -in available instead of this. how do we populate table from a block in Forms 10g?
View 6 Replies View RelatedForms :: F5 Shows Available Block Details
Sep 29, 2010When I execute my form, on pressing key F5 it displays the all available block names in the form. I want to restrict this.
View 5 Replies View RelatedForms :: Populate Data Block
Aug 14, 2013i have created on query block , upon pressing the button there is a wehre clause in the block which will filter the records based on all alike items from two tables but my problem is , in one table there is no information of struct and in other there is struct information or data, what i want is even if i pass a parameter in the where clause all the records should be filtered.
CREATE TABLE OT_ACTUAL_ACT (ITEM_CODE VARCHAR2(30),ITEM_NAME VARCHAR2(30),WO VARCHAR2(12),STRUCT VARCHAR2(12))
INSERT INTO OT_ACTUAL_ACT(ITEM_CODE,ITEM_NAME,WO,STRUCT)
VALUES ('1001','HEA100X10','300',null);
[Code]...
I am getting this
ITEM_CODEITEM_NAMEWOSTRUCT
1002 HEA100X2230030010
i want all the records
ITEM_CODEITEM_NAMEWOSTRUCT
1002 HEA100X2230030010
1003 HEA100 300
1001 HEA100X10 300
Forms :: Deleting Records From Block
Aug 2, 2011I want to delete records from block in the form.could you explain where(in which trigger) should i write set_block_property.
View 9 Replies View RelatedForms :: 11g - Create Data Block?
Jul 6, 2010I m using Forms 11g. when I m trying to create Data Block & Select table Name then I received the following error.
View 5 Replies View RelatedForms :: All Block Fields Are Disabled
Dec 11, 2011I am using Forms 6i in Application. In Form, After i enter the data and saved then,if i retrieve the data by using Ctrl+F11, all the fields of data block turns to be disabled (insert not allowed, update not allowed) of course i am getting the data.If i close the application, and open freshly it works good (insert allowed, update allowed).
View 1 Replies View RelatedForms :: Selection Limit On Block?
Apr 18, 2012I have a question regarding a selection limit from a list of values. The table where my IDs (unit_codes) come from has another column called 'points'. each ID has its own number of points. Is there a way to put a selection limit on the display field that points will be placed on?
FOR EXAMPLE: a course block has a selection limit of 70 points, A person named someguy selects :
music = 20 points
maths = 20 points
mathsXTRA = 40 points
**ALERT!!! - U can ONLY select 70 points worth of units**
Forms :: Clear Block If Value Change?
Dec 28, 2011I Require to Fetch the Group of Value in Item Block Selected through the User Selected LOV Value in Master.
Through Loop i Fetch the Records in Item Block.
When User Change the Selected LOV Value Require to Clear the Item Block.
BEGIN
FOR NRM IN (SELECT MTRLTYPE,STATUS,
MTRL_NO,MTRL_ID FROM JAWOADMIN)
LOOP
GO_BLOCK('NRMTRL_ITEM');
:NRMTRL_ITEM.NRMTRL_TYPE := NRM.MTRLTYPE;
:NRMTRL_ITEM.REMARKS := NRM.STATUS;
:NRMTRL_ITEM.NRMTRLREF_NO := NRM.MTRL_NO;
:NRMTRL_ITEM.NRMTRLREF_ID := NRM.MTRL_ID;
NEXT_RECORD;
END LOOP;
END;
How to Clear the Block before the above loop.
Forms :: Master Detail Block
Feb 20, 2012I have face a problem with master detail block,
we have two tabular block first one is master and sencond one is detail when we insert detail item it proper work and when when move next record in master block then it ask for save, I want to user enter all record and when he save with button then it save other wise no. but when he move any record in master block all realted record show in detail block.
Forms :: How To Go Back To Previous Block
Feb 21, 2012I'm making a menu in my form, wherein it has FILE, TRANSACTION and REPORT. Under FILE it has BACK, and LOGOUT. In my back menu item, i want to go back to the previous block or previous module. I used previous_block but it's not working in some of my blocks.
View 8 Replies View RelatedForms :: How To Highlight Record In A Block
Jun 9, 2011As from the title can i high light some records in a data block? I am fetching almost 10 - 12 records in a datablock and it is working perfectly fine. but there are some records coming in the block which i want to make permanently red or dimmed just showing as they are black listed. is this possible?? or i have to try some other way??
View 10 Replies View RelatedForms :: Data Block Using Query?
Mar 1, 2010I wanna to load data in a data block using sql which using multiple table, views based on condition
View 7 Replies View RelatedForms :: Not Entering Into A Block (non-database)?
Jun 1, 2012I am using a block the problem is I am unable to fetch the data into the block when I have entered the execute_query even tried with the pre-block trigger but not getting the message which is in pre-block how to over come with this..struggling since two days but unable to resolve it
View 2 Replies View Related