Forms :: Populate Record In Data Block
Jul 14, 2010
My Requirements:
1. i want to create form for student's attendance.
2. for this purpose i create a form . and create 2 Data Blocks
1. Non Database Data Block (layout type: form)
2. Database Data Block (layout type: Tabular)
3. in Non Database Data Block i add 3 Items.. on the basis of i get the records from database and show them into my into my 2nd Data Block...
4. my problem is this that how can i get records from database and show them into my forms and then save thats records into my table by using Database Datablock.
View 2 Replies
ADVERTISEMENT
May 3, 2011
i have two blocks called BLOCK1 AND BLOCK2
BLOCK1 is a multi record block with a field, FIELD_A
BLOCK2 is a multi record block with fields FIELD_B,FIELD_C,FIELD_D
i have a button on BLOCK1 called 'FETCH'.
The requirement is when_button_pressed on 'FETCH'. BLOCK2 must be populated for each record of BLOCK1. Population logic is based on, values from a database table TABLE_A which has got column values corresponding to all fields of BLOCK1 and BLOCK2.
View 7 Replies
View Related
Aug 14, 2013
i 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
View 1 Replies
View Related
Dec 3, 2010
TABLE_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 Related
Aug 10, 2013
I have a form with 3 blocks in our oracle application. Block1 is a single record block. Block2 and block 3 are multi record blocks with no of records 5. Block1 and block2 are in same canvas1 of a window1. Block3 is in canvas2 of window2. There is a relation between block1 and block2. Another relation with block2 and block3 is also available.
Now my issues is while creating a record, first i entered the data in block1 (which is a single record block). Then i entered data in five rows of second block. Then i entered data in block3(multi record block) by pressing the button in block2 (each button for each row). But before saving the entire form, when i checked the data in block3 by pressing the button of first record of block2, screen shows empty.
Code in button of block2 is as follows
show_window(WIN2');
Go_block('BLOCK3');
Code in button of block3 is as follows
hide_window('WIN2');
go_block('BLOCK2');
If post; is included in block3 button. then problem we will be solved. But we don't want to use post; as it lock the table.
View 16 Replies
View Related
Jun 15, 2011
I have data block that has hundreds of records. On a screen I display 20 records at a time. On that same screen I have "find badge" function where user types badge/employee id and presses a button to find the record in a data block. I have no problem finding the records in a list and pointing the curser to appropriate record. My question is (which is a user request) if the badge/employee id is found to make that record to be the first record in a list.
View 2 Replies
View Related
Mar 2, 2011
Create a form based on the following output use EMP Table
Create a non Database Block i.e Control Block----> Dept No
Create a Database Block -EMP
Create an LOV for the Dept no from dept table.
For the Current Dept No . Populate the Employee Records
View 3 Replies
View Related
Aug 6, 2010
i want to popultate record in list item.... and write the follwing code...
PROCEDURE POPULATE_REC_IN_COMBO_BOX IS
RG_NAME VARCHAR2(500) :='RGGROUP';
RG_ID RECORDGROUP;
ERRCODE NUMBER;
BEGIN
[code].....
when i call this code then it returns the 2 errors:
1. FRM-41072: Cannot create Group RGGROUP.
2. FRM-41076: Error populating Group.
View 16 Replies
View Related
Jul 24, 2010
I 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".
View 3 Replies
View Related
May 7, 2012
when i press when button pressed trigger, i want first the form will delete all the previous data and then populate the data from the table, that's why i used clear_block first, but this clear_code is not working here. my coding is given below
go_block('show');
clear_block(NO_VALIDATE);
declare
cursor c1 is select *
from qtr_demand order by 1;
begin
[code]..........
View 26 Replies
View Related
Sep 18, 2012
How do I insert a new record in a Data Block, and the standard is always insert a line below, you could add a record above?
View 1 Replies
View Related
Nov 19, 2010
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
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
View 12 Replies
View Related
Jun 9, 2011
As 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 Related
May 18, 2010
I have two block namely block-A, Block -B
Block A data queried from a view (it have 10 columns).
Block b (it have 5 columns all columns are same in block A column)
When i query of block - A i have to receive the same copy in Block B too.
View 6 Replies
View Related
Aug 4, 2013
I have a master detail form and in the detail block when i am scrolling up the records are getting disappeared , but actually they are not getting deleted, once if i requery the data will appear, what could be the problem.I am using the property change record for block.
View 5 Replies
View Related
Mar 9, 2011
I have a multi record block, which, once filled, I do not want to allow manual insertions from the last new record. For that, I do:
set_block_property('block name', insert_allowed, property_false)
The problem comes, when I want to change a checkbox item column from one record already informed.
I can not do that, after setting the block property, although I change item properties accordingly.
View 6 Replies
View Related
May 1, 2013
I have problem i want to to display in message all the values of block in for example when i create the fourth record the three already records are show in message..actually first i want to in message than i would populate pl/sql table. the code is at block leve when-new-reocord-instance
************************************************************
declare
v_record number :=1 ;
v_cur_record number;
begin
v_cur_record :=:system.cursor_record;
[code]......
actually in block there are three record and this message should be display for the three time but the loop is executed more time.
View 25 Replies
View Related
Apr 22, 2010
My form consist two datablock cust_mstr,cust_dtls, each customer code consists two or three contact details records, when i delete the single detail record instead of deleting single record it deletes all the details records from cust_detail table.
Here by i attaching my form for your reference pls find the code in delete button
View 12 Replies
View Related
Jul 17, 2012
I am creating a record with the items - S_No, Product_Name, Selling_Qty, Price.
Checking the total qty (Tot_Qty) from the purchase stock - table1 and already sold out qty (Sold_Qty) of the product from table2.
Consider the following values: Tot_Qty = 200; Sold_Qty = 50;
Now i create a first record of the form as follows: here on selecting the Product_name from LOV, will display the Selling_Qty item - which can be edited (Selling_Qty = Tot_Qty - Sold_Qty) and its price.
S_No Product_Name Selling_Qty Price
1. KeyBoard 50(150) 200
2. KeyBoard 30(150) 200
3. KeyBoard 50(150) 200
Note:
[value given within () are displayed automatically after selecting the prod]
My prob is, when i am entering next record, it displays the same 150 as qty, which have to be 100. After selecting the product from LOV, it should calculate & validate as shown below: which means, previous record value of Selling_Qty also have to be subtracted and displayed.
S_No Product_Name Selling_Qty Price
1. KeyBoard 50(150) 200
2. KeyBoard 30(100) 200
3. KeyBoard 50(70) 200
Is there any built-in functions to retrieve previous record value?
View 6 Replies
View Related
Feb 12, 2012
I want to ask what's wrong with my multi-record block.
When i click a node on my tree, it should display the records on it. For example, my root node is Sections, the parents are 1st sem and 2nd sem. In each sections in 1st sem, whenever i click a child node, it should display on display items. I have set its number of items displayed to 9. Since each sections have 9 subjects. The problem when i run it is that it displays many rows.
View 35 Replies
View Related
Sep 16, 2010
I have Two cursor record block..which is attached in form..
My TASK IS
In my first Block, When DBCR Column = 'D' Then in backend this column value should be save as a '1'
WHEN DBCR Column = 'C' Then Then in backend this column value should be save as a '2'
My Both Field is on Data Block...
In Property palette of this field can we write any decode condition..so it reflects directly on database.
View 2 Replies
View Related
Jun 13, 2012
i want to update record that is fetched based on join condition on form
1. made a block manually :::: EMPSAL
2. Query DATA SOURCE NAME :::: EMP a, Sal b
3. Where Clause :::: a.empid = b.empid
4. DML DATA Target Type :::: Table
5. DML DATA Target Name :::: EMP a, Sal b
6. All Columns are marked a.empid, a.empname, b.sal, b.date etc
It does not allow me to update record.
View 1 Replies
View Related
Apr 21, 2010
i have form have one multi record block and sing record block. In multi record block having an item namely Excise_value. I want to find the sum of total Excise_Value for all the record. How to accomplish this.
PS: I want to use the Formula/summary property in forms
View 2 Replies
View Related
Sep 5, 2012
I have a problem validating a multi-record block. I need to put the validation after the user clicks save. The custom validation should run through all the records in the multi-record block. But instead of validating all records, it will only validate the record where the cursor is located before the user hits save.
View 1 Replies
View Related
Sep 14, 2011
Could i uncheck the checked checkboxes in a mutirecord block by any command?
View 1 Replies
View Related
Jun 29, 2011
I am working on forms 6i.
I have datablock 'EMP', it's multi record block. I have a button 'CREATE', I have 'commit_form' in 'When button pressed' trigger, to commit records. It's working fine.
Now, i have a check box in the same block, i want to insert records which are checked only.
View 7 Replies
View Related
Apr 8, 2013
In one of my form , there is some code "next_record;" in the key-next-item trigger of one field.Here before going to next record, it is executing the WHEN-VALIDATE-TRIGGER of all the items in that record.Is it the default behavior of oracle forms?Can we override this?
View 3 Replies
View Related
Aug 9, 2010
I'm having a multi-record detail block in my form and after querying the form, when I scroll through the scroll bar, it is hanging (freezing) just before reaching the last record.
I have noticed that it never hangs if I use arrow keys to scroll between the records. It only hangs when I use scroll bar or page down key.
Regardless of the number of records fetched, it only hangs when I click the scroll bar (or press page down key) to fetch the last record.
It happens to all my custom forms and I'm developing this for Oracle EBS Apps 11.5.10.2. Oracle JInitiator Version is 1.3.1.21 and my form builder is Forms 6.0.8.28.0.
View 9 Replies
View Related
Mar 28, 2011
The main qn is in the subject line.
I have used the following code
GO_BLOCK('CHILD_BLK');
FIRST_RECORD;
LOOP
IF NVL(:CHILD_BLK.SELECT_FLAG,'N')='Y' THEN
V_REC_NO := GET_BLOCK_PROPERTY('CHILD_BLK',CURRENT_RECORD);
SET_ITEM_INSTANCE_PROPERTY('CHILD_BLK.ASSET_DESC',
V_REC_NO,
[code]....
View 5 Replies
View Related
Dec 8, 2010
I'm using Oracle forms 10g. In the form i have this multiple records under one block. After performing the query, all records are cannot be updated. And i have this buttons at the right side that will enable the certain item that can only be updated. My problem is i cannot enable the item in the first record,instead of first record all records in that item was enable.
View 8 Replies
View Related
