Forms :: User Clicks On Declaration_no From Header Table / Other Records Will Be Displayed
Jun 26, 2013
I need to populate records from a child table when the user clicks on a record in the header table..The difficulty is that the user needs to be able to edit a field from the child table and there could be 1 to many records. When the user makes a change , I don't want the 'do you want to save changes' error to appear..
the user will only be able to update field 'amt'.When the user clicks on 'declaration_no' from the header table,other records will be displayed. URL.....
View 5 Replies
ADVERTISEMENT
Oct 26, 2010
I have a requirement like this, There is a temporary table with one number column. This column would be updated in between pages trigger. In the header I want to display the value from this temporary table on each page. I tried this by putting a frame and displaying the values, but it displays same value for all the column.
The table is properly getting updated in between pages trigger. I just want to know how to print the refreshed value in the header.
View 3 Replies
View Related
May 11, 2010
I have a block in the form which is based of a table as data source and so when i query on the form using a execute_query inbuilt statement is fired and all the records in the table behind is retrived and displayed. Also if i need to update any record i can do in on the screen and use commit_form so that all the changes go into the underlying table. Now my problem is when i retrieving my records i want to filter those records based on some conditions to be displayed in the form and not all records to be retrieved. Is it possible to do it if I am using the execute_query inbuilt and my block is based of a table?
View 8 Replies
View Related
Jun 25, 2010
i have a cursor which selects the codes based on the school records now i have a multi record block b1 the requirement is that if no of records selected in cusor is 10 then in block b1 10 records should be displayed and if it is 15 then 15 records should be displayed. Is there any way that i can set the no of records displayed in a block dynamically.The block b1 is non database block i am only using a create_record to populate the block.
View 2 Replies
View Related
Dec 28, 2010
Actually m working on oracle 10g forms. I have a list item in which no. of records displayed is 10. I am populating this list item through a record group. I want when user select a value from first record then he should not be able to select the same value in further record of that list item.
View 12 Replies
View Related
Mar 31, 2011
I am currently on a project which has a requirement of changing the number of records dynamically. Oracle Forms version 10g.
View 2 Replies
View Related
Jul 20, 2011
In my application (forms6i) initially data will be displayed in a non-database block after a lot of calculations and validations which is time consuming.
Now, if the user want to print it as a report, we store the displayed data in a dummy table and run the report using that dummy table and then delete records from it.
Is it possible to pass the records displayed to the report as a parameter so that I can avoid Unnecessary add/delete records?
View 1 Replies
View Related
May 30, 2010
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:
mitem1-value1 ditem1value1 ditem1value2 ditem1value3
mitem1-value2
mitem1-value3
mitem1-value4
When the navigate down in master items, then the corresponding detail values are being shown on the same first record.
View 1 Replies
View Related
Sep 4, 2011
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.
View 3 Replies
View Related
Mar 11, 2011
i got a prob in executing a query in my oracle.TRANSACTIONLIST is the table and my query is..
select * from TRANSACTIONLIST where USER_ID = '07751A1247'the table has 2 records with that user id.
But it is given result as "no data found".
View 4 Replies
View Related
Mar 26, 2012
I am using Forms 6i,Oracle Apps... I have database block.... generally we can retrieve the all the records by press F11 and Ctrl F11.... but my requirement is i have to restrict the user that they can access the records based on the condition ...
For example....let we take emp table....I have to restrict the user that they can query dept no 10 employees only.
View 11 Replies
View Related
May 29, 2010
I want to update / insert records from one user to other user therefore I write this code in my form but it gives me error.
REPORT_DETAILS is a detail table of REPORT_PARAM, given code is working fine at master tables.
Form always goes in TOO_MANY_ROWS exception.
Correct my code, my requirement is: if data found then update else insert new record.
declare
cursor c1 is select * from factory_data.report_details order by rd_rp_id;
rec c1%rowtype;
v_check varchar2(1) := null;
begin
for rec in c1 loop
[code].......
View 7 Replies
View Related
Jul 13, 2010
I have created one tab canvased form
On first tab I am taking input (search criteria)
on that input i am trying to display all records one by one as user click on next record button....
for that i used when-tab-page-change trigger for first record display and it display correctly.but for further record what should i need to write on next_record command button so all record i can see one by one.
View 1 Replies
View Related
Jun 26, 2012
CREATE TABLE CURR_STS
(
LOB VARCHAR2(100 CHAR),
FP VARCHAR2(100 CHAR),
BRAND VARCHAR2(100 CHAR),
ITEM VARCHAR2(100 CHAR),
SUB_ITEM VARCHAR2(100 CHAR),
PART VARCHAR2(100 CHAR),
COST NUMBER
[code]...
ITEM not in CURR_STS table not to be displayed ( HERE SKU2) , but SUB_ITEM, PART coming under a ITEM if present in SAME ITEM in CURR_STS ( here SKU1 is common in both CURR_STS and PRIOR_STS) to be displayed. Trying to achieve this through OUTER join queries.
SELECT a.lob,a.sku,a.mod,a.part,a.cost curr_cost, b.cost prior_cost
FROM curr_sts a, prior_sts b
WHERE a.item=b.item(+) and a.sub_item=b.sub_item(+) and a.part=b.part(+);
View 3 Replies
View Related
May 13, 2011
is that datablock should have related to show the stacked which is hidden in content canvas
i have attached the stack.fmb
View 9 Replies
View Related
Mar 27, 2012
In my form I have a submit button, when i click on it a sequence number to be generated and displayed in a text box.
I have created a sequence and tried inserting into table, it works fine however it's not getting displayed in form.
Note: Tried giving sequence.sequence_name.nextval in initial value of the text box, didn't work showed FRM-11324 error.
--When button pressed--
DECLARE
v_seq number(20);
BEGIN
select seq_name.nextval
into v_seq
from dual;
[Code]...
View 15 Replies
View Related
Nov 29, 2010
Is there any way could alter the sequence depending on specific condition to start with 1 in the form builder?
i wanna to reset the sequence to 1 whenever the month change.is there any way?
Could i make detail block invisible and whenever button pressed i will display the block? I want to put the where clause for that block in the button and if the button did not pressed i want to display nothing in the detail block?
View 1 Replies
View Related
Dec 10, 2010
Now I want to use an existing MS Word file from file system (e.g d: est est1.doc) and add header & footer (e.g docname Page x of x) using Forms 6i.
View 3 Replies
View Related
Dec 25, 2011
when a user change or delete any record or row in forms data automatically move to other table because i want to compare old and new record.
View 8 Replies
View Related
Oct 21, 2010
My issues is when I changes the data in Header block the detail block should corresponding data immediately related to header on the detail lines.
The form is based on master detail relationship.
View 7 Replies
View Related
Dec 29, 2012
i want to display all the records of my database in a table with scrollingexample if i have 3records in my DB so a table must have 3records too !!!this is my code :
DECLARE
Cursor cur IS
SELECT numb_ph AS phone,
name_emp AS name
[code]...
but the problem 's all records of my DB are display in one record (to view another record i use the scrolling ..
View 31 Replies
View Related
Jul 20, 2011
Im using oracle forms 10g. i want to take backup of user's table.
i.e, scott user has 4 tables. if i login as scott user and select the tables what i have to take backup using check box and click a backup button,the selected tables backup and stored in .MDB(MS Access).
How to achive this?
View 4 Replies
View Related
May 23, 2011
How can we design a form with header level and line level. here i need to place a button in header section.when we press that button, line level values should be populate.
View 1 Replies
View Related
Nov 10, 2009
I have build a sw containing 20 forms & 35 reports. I have created users table.
Now I want to assign different rights to different users like update, view , update, print, delete etc etc. Enable disable add/delete/update buttons on basis of user rights.
View 11 Replies
View Related
Jun 6, 2013
I want to provide excel sheet with column header only to user, with the push button of oracle forms.(i.e user suppose to get the excel sheet when he press the button on the form).
View 3 Replies
View Related
Nov 24, 2010
I have three blocks in my form , header,activity and item.One header can have many activities and one activity can have many items.I need to keep track of item value totals in header from items under each activity.
View 1 Replies
View Related
May 29, 2011
I have two blocks.In header 2 columns are there same columns in line how to populate default values in line level based on header?
View 1 Replies
View Related
Nov 24, 2011
After running my report I generate into the file by delimited type and then I save as it by XLS extension.The problem is each row of this excel file has header repeatedly!
View 4 Replies
View Related
Sep 15, 2013
I have a master detail based transaction form, i want to create three check boxes on header block, based on selection sorting must happen on detail block which has three fields, for example there are three fields item_code,item_name,item_qty, if user selects first check box then sorting will be on item_code, if he presses second then sorting should be based on item_name, likewise if he presses check box three then sorting will be based on qty, if choses two or more fields then sorting will according to that combined order.
View 4 Replies
View Related
Jun 17, 2009
I am trying to write an update statement which updates the User IDs in one table with the User IDs in another table. However I need to update statement to ignore any duplicates that are in the tables.
View 4 Replies
View Related
