Forms :: Two Cursor Record Block - Decode Function

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


ADVERTISEMENT

Forms :: How To Read Values In A Multi Record Control Block Using Pre-insert Trigger (block Level)

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

Forms :: Use Cursor To Get Data From DB To Control Block

Feb 7, 2010

i want to use cursor to get data from db to "control block "(db item =no ) this data had where clause depend on item on other block

this my code :

declare
cursor get_sol is
select SOL_STEP,PROB_ID
from MI_SOLUTION
where PROB_ID=:MI_FORM_PROB.PROB_ID;
begin
go_block('control');
[code]......

when am using when_validate_item trigger error raise :

FRM-40737:Illegal restricted procedure next_record in when_validate_item

that's the trigger ? or how to solve ? in case of execute query in what trigger i will write the same code to get data in case of execute query by user .

View 9 Replies View Related

Forms :: Get Block Name From Cursor Focus Location?

Jul 27, 2010

I have a delete button at the bottom of the form and have two blocks on top of it. I need to know which block i have the focus on or selected the record on pressing the delete button so that I go to that block and do a delete_record from that block. I came across :system.trigger_block which says it gives the name of the block where the cursor was located when the current trigger initially fired. But whenever i use it only returns the name of the block the delete button is located in. Instead i wanted to know where the focus of the cursor was or which record was selected in the above 2 blocks to go to that block and delete the record.

View 1 Replies View Related

Forms :: Delete A Record In A Cursor

Mar 3, 2012

this is just the continuation of my previous topic,

After I bound data into the textboxes, now I want to delete it when I mistakenly click on the same data twice.

this is my screenshot:

View 4 Replies View Related

Forms :: Updating A Record In A Cursor?

Mar 3, 2012

when I updated a record in my form check my screenshot: and clicked save button the result was:

as you can see in the message at the bottom, it has 18 records. And since my original data(subjects) are just 9. And also the grades that I input didn't display all.

This is my code in when-new-block-instance trigger:
DECLARE
CURSOR studgrade_cur IS
SELECT e.student_id, s.subject_code --, g.grade

[code]...

View 39 Replies View Related

Forms :: How To Highlight Record In A Block

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

Forms :: Cursor (control) On Current Record

Jul 18, 2011

In my form line level block contains 100 records.i will check the check box for line number 96 and 97. Then i will press save(I have written some logic here) button it will generate one number for selected check boxes. After generating this number cursor(control) should be on same line number 96 or 97.

View 10 Replies View Related

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 View Related

Forms :: How To Populate Multi-Record Block

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

Forms :: How To Copy Multi-record Block Into Another

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

Forms :: Traversing In Multi Record Block

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

Forms :: Multi Record Block - INSERT_ALLOWED

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

Forms :: Print Record At Block Level

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

Forms :: Delete Detail Block Single Record

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

Forms :: Data Storing In Multi-record Block

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

Forms :: Retrieving Previous Record Value Of Same Item In A Block

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

Forms :: Multi Record Block Not Displaying Items

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

Forms :: Update Record In Join Condition Block?

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

Forms :: How To Find Sum Of Item From Multi-record Block

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

Forms :: Personalization Validating A Multi-Record Block?

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

Forms :: Uncheck Checkbox In Multi-record Block?

Sep 14, 2011

Could i uncheck the checked checkboxes in a mutirecord block by any command?

View 1 Replies View Related

Forms :: Click Checkbox And Then Loop - Current Cursor Going To Last Record

Dec 7, 2010

i m using oracle 10g 10.2.0.2 version.i create a form and using check box on this form.when i click this check box then loop is using behind it.and current cursor is going to last record

i want if i click 4 record then cursor is still showing on 4 record mean i click which record after using loopmy current cursor is showing on that particular record

how it is possible

View 1 Replies View Related

Forms :: How To Insert Records Checked In Multi Record Block

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

Forms :: Custom ORDER BY In Multi-record Data Block

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

Forms :: Next-record Executes When Validate Triggers Of All Items In Block?

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

Forms :: Hangs When Scroll Bar Reaches Last Record In Detail Block

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

Forms :: How To Disable Single Record In Multi Non-database Block

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

Forms :: How To Enable One First Record Item Under One Block With Multiple Records

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

Forms :: How To Check For Unique Value In Text Item In Multi-record Block

Mar 13, 2013

I have a multi-record block with several text items.

On one of the text items i want to enter a value and then check whether the same value for the item has already been entered on any other records within the block.

If it has already been entered then i want to display a message and null out the field.

I have tried using app_record.for_All_records from a when-validat-item trigger but this does not work as you get a 'FRM-40737 Illegal restricted procedure go_block in when-validate-item trigger ' error

View 17 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved