Forms :: Highlight A Particular Record
Sep 14, 2011In a form which displays 10 record at one time. I want to highlight the highest salary. How do I determine and highlight the salary?
which trigger should I use ?
ADVERTISEMENT
Forms :: 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 :: Highlight Field Value With Blue Color
Jun 25, 2011My requirement is, when ever cursor entered into a field, the value of the field will highlight with Blue color and text color will be white, if field is not empty. It the feature of oracle application.
View 5 Replies View RelatedApplication Express :: Highlight Words - Only First Occurrence?
Feb 14, 2013'm using the "Highlight Words" column formating for a report. There, I'm using the item syntax: &P1_RENVOI. Problem is, when the report appear, only the first occurence of the value of item "P1_RENVOI" is in red for every field in that column.
Is this a normal feature or should all occurences be put in red?
Forms :: Populating Values To Record Group From Multi Record Datablock
Jul 26, 2012My procedure proc_ex is in when_validate_item trigger
I have one Multi Record data block in my form with values in its items
I need to Populate multi record block values to one Record Group using
add_group_row,
add_group_column,
set_group_char_cell to populate values to record group
Let us suppose my multi record data block looks like
item1 item2 item3 item4
10 20 50 70
25 15 30 45
45 90 47 38
75 25 85 90
30 56 78 80
how to populate these multi record datablock values to Record Group ???..Eagerly waiting for your Replies
Application Express :: Calendar Highlight - Previous Day Picked Instead Of Today
Sep 25, 2012Apex 4.1.
I am using calendar to display some data but there seems to be some problem with the focus for current date. For instance : 25 Sep 2012 is today's date but the calendar focus somehow remains on 24th Sep 2012 and I am failing to understand where do I set this right. Few users see focus on correct date while few see it on previous date.
Also in another tab of the application I am using a Interactive report which displays data based on whatever calendar entries were made earlier. Here I have two regions Today and Tomorrow which pick the values from report and display them in respective region but here too Today(picks yesterday date) and Tomorrow(picks today) .
I am confused as to where to set this right because like I said few users (based in AU) are seeing this incorrect values while users located in another region see it correct.
Application Express :: How To Highlight Entire Classic Report Column To Red
Sep 20, 2012We have a requirement, to highlight an entire column of a classic report based on a query to red. So if the search of the report returns column1, column2 as the output. Column 2 (text) should be highlighted in red across all results rows.
In some forum responses, I see using some id format, one can try to highlight a single column in a row. Not sure how can this be done across the whole column of multiple rows.
Forms ::create History Record For Each Record Whether Updated Or Not
Sep 13, 2011I have a fairly standard Purchase Order form which contains pre-loaded data (been uploaded from an XML file).When the Purchase Order is processed, the form updates a Price History table only if the Price on the PO_Details changes.The code for updating the price history table is contained in a PRE_UPDATE trigger on the PO_Details Data Block.
No other data changes on the PO_Details table.I now want to change this so that the Price History table is updated even if the price does not change i.e I want to create a history record for each record on the PO_Details irrespective of whether it was updated or not.
Is there an alternative trigger that I can move my code to (ie move it from PRE_UPDATE) to some other trigger that is fired for each PO_Details record even if there is no change.
Forms :: Only New Record Have Saved Last Record No Longer Exist
Jun 29, 2013I create a data block on a table when I am inserting new record only one record have been saved. Last record no longer exist.
View 4 Replies View RelatedForms :: Choose Lov In First Record That Won't Be Display In Second Record Lov
Sep 10, 2012I have one multi record block in that i have one LOV..If i choose lov in first record that won't be display in second record lov...
View 4 Replies View RelatedForms :: When User Change / Delete Any Record / Row In Forms Data Automatically Move To Other Table
Dec 25, 2011when 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 RelatedForms :: Insert Record Into Lov Through Oracle Custom Forms?
Oct 8, 2013I have a LOV in a custom oracle forms.this lov is linked to a record group.
Presently the column on which lov is created does not contain any value.
I want to insert value into the lov through the forms.
I am not able to insert data into it through forms
Forms :: Do You Want To Save Record
Aug 22, 2005I have created a form which as two block as master and detail.I am facing two problem in my detail block.
First: When I populate records in detail block, it prompt a message 'Do you want to save record ?'.
Second : When I alter any value in detail block and move to next record, it prompt a message 'Do you want to save record ?'
Is there any way where, system don't prompt me a message for saving record and user can continue with changes and save the records when he desire.
Forms :: Record Is Getting Saved Twice
Mar 8, 2012My record is getting saved twice every time I push my button to commit changes to my DB.I have already records from my table and when I click for that record to update the grade. the same record is getting saved twice.I have put my queries in on-update trigger to update the grade of my record. I check my query, don't have errors. I don't know what's wrong with this.
View 24 Replies View RelatedForms :: Each Second Record With Different Background_color
Jul 9, 2004To improve legibility, I would like to display always the second row with another (lets say green) background_color. Therefore I created a BLOCK - Post-Query Trigger containing the following lines:
--IF (:EMP.COMM IS NULL) THEN
IF (MOD (TO_NUMBER(:SYSTEM.CURSOR_RECORD), 2) = 0 ) THEN
SET_ITEM_INSTANCE_PROPERTY('EMP.ENAME', CURRENT_RECORD, VISUAL_ATTRIBUTE ,'GREEN_BACKGROUND');
END IF;
NULL;
My first problem: I do not know how to the determine the whole record, therefore I just used EMP.ENAME
Second problem: The green background starts at record number 7 (if the first record is number 1, (is this so, or does it start with zero ??)), and then number 9, 11, 13 (from scott.emp) has a green background-color.
Forms :: Could Not Reserve Record (2 Tries)?
Nov 5, 2011I administer a database oracle 10g for a small company . the we mostly work in oracle forms 6i and after 2 3 days a message springs up "Could not reserve record (2 tries), keep trying?" when a user tries to save a record . Is there any decent solution to this problem other than restarting the Db server all over again .?
View 4 Replies View RelatedForms :: Display Next Record?
Apr 22, 2010I have a form in which the fields are not database items i want to display the next record, i know i can use the next_record for the same but it does not work since it is not the database item, is there any way when the item is not the database item and i can see the next record. I use the cursor for loop but since it fecthes all the records in one go it cannot display one record at the time in the form..
View 3 Replies View RelatedForms :: Record Status Bar?
Jun 2, 2011i am migrating forms 6i to 10g, when i compile one form to checking purpose all are successfully fine but the record status bar not showing there fore message are not appear how to solve this problem
View 1 Replies View RelatedForms :: Populate Record Using LOV Value?
Mar 2, 2011Create 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
Forms :: How To Update Record
Jan 1, 2013I want to update record when i press the button "update" but i don't have idea ,if i will create a new forms ,or new block or the update is made in the same form.
View 10 Replies View RelatedForms :: How To Stop Going To Next Record If It Is Last One
Jan 31, 2012how to stop going to next record if it finds the last record. Because when i click my next button(it is the last record), i try to click my previous or first button but it won't go back, enter-query mode is the error message.
View 9 Replies View RelatedForms :: Trigger For Next Record
Jan 2, 2012I have develop the New Form.Their as a Validate require to Include in it.without saving the Current Record, it not allow to enter the New Record.
Which Trigger Used for this Validate and How to done it.
Forms :: 6i Duplicate Record?
Nov 4, 2013I am using forms 6i, I want to insert a new record in the form based on an existing record (so I do not have to type all the values)
is there a shortcut key that I can use to copy the entire record and then when I say insert new, I just paste the record I just copied
Forms :: How To Delete Record
Jun 27, 2011i m using oracle 10g forms
in one form
there are multiple records shown in this form
i m using one delete button
coding is
declare
v_yes_no varchar2(1);
begin
v_yes_no:=display_alert2('alert_2','Caution','Do you want to delete current record');
[Code]...
but when i press this button then one message shown on secreen
you can not delete this record
when i debug the form
message shown through on error trigger
i can not understand why this message ocuured
and record not deleted
no any constraint use in this form
but if i delete record from backend then records delete successfully
Forms :: How To Clear Record
Feb 13, 2012In 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 ?
Forms :: Set Record Property
Aug 28, 2012this from has multirecords and multiblocks for every date it shows employees' attendance record, there is a button that should disable selected records for that specific date
**part from the code**
LOOP
if :ATTENDANCE.SIGGNED = 'Y' AND GET_RECORD_PROPERTY(:SYSTEM.CURSOR_RECORD, 'ATTENDANCE',STATUS) = 'CHANGED' THEN
:ATTENDANCE.LAST_UPDATED_BY:=fnd_global.user_id;
:ATTENDANCE.LAST_UPDATE_DATE:=sysdate;
SET_RECORD_PROPERTY(:SYSTEM.CURSOR_RECORD, 'ATTENDANCE',ENABLED,PROPERTY_FALSE);
[Code]...
what happen that it is confirming that selected records are disabled AND it is NOT!!
**i can still change the records if i want **
but if I changed the date and go back "the date which i disabled its records" (reload that data) then it will be disabled
finding a way so it will be disabled immediately so i don't need to change dates to be disabled
**maybe if there is a code that will refresh records ?!
Forms :: Record Locking?
Oct 21, 2010I have developed a form, containing 5 tab pages and also referencing to 5 tables.tab page a of table a some fields are required and some or not.when i open form and start entering record, and then i change mine and dont enter and want to navigate to some other page, it simply allows me to leave it blank and move to some other tab page.
tab page b of table bsome fields are required and some or not.when i open this tab page and one i click in the first field and then do not enter anything in it and want to leave it , it does not allow me to leave blank.what could be the reason. why one tab page allow me to leave blank and navigate and why the other does not?first field of both tab pages are required.
Forms :: Retrieving Record
Sep 6, 2012I have two blocks on which I am having relation based on booking number and employee code. As I am doing a query, booking number is getting fetched in employee code's field and employee code is getting fetched in booking number's feild. Because of this, I am not able to update the form. It is giving me error unable to update record unique contraint voilated for primary key which is quite obivious. But why the data could get shuffled in each others field though during inserting its going properly.
View 7 Replies View RelatedForms :: Dynamic Record Group For LOV?
Feb 22, 2011I want to create a Dynamic record group and associate it to a LOV.for example: I want that for a set of people A, i want to fire the query in lov:
select * from emp where (condition 1)
and for another set of people B, I want to fire
select * from emp where (condition 2)...
How could I achieve it?
Forms :: Query In Record Group
Mar 6, 2011I am calling one record group to get the security permissions. That RC is associated with one SELECT query. That RC is already created and used before i call. I m just re-using the same. But my form/module dont have privilages to see the QUERY in that recrod group. I just want to see the query in side that record group. how to print the SELECT query from the record group.
p.s: That record group is built in run-time.