Forms :: 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
ADVERTISEMENT
Forms :: 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 :: How To Display Current Record
Mar 12, 2013I have problem about displaying current records with same table(tbl_pawnitem). I have 2 transactions which are the pawned transaction and for sale transaction. and both transactions save into tbl_pawnitem table..i want to display only in my list the for sale transaction without deleting the records of pawned transaction. what condition i will use?
View 5 Replies View RelatedForms :: Display Record On Non Database Item?
Sep 17, 2012I want to display my query select * from Clinical_Chart_CCHPI in non database item which is 1000 Char. I want to display that query when my forms execute.below is the test case.
Create table Clinical_Chart (Chart_Number Char(12),MR_NO Char(13));
Create table Clinical_Chart_CCHPI (Chart_Number Char(12),serial_number number,Date Date, Remarks Varchar(1000));
--------------------------
insert into Clinical_Chart(1,1);
insert into Clinical_Chart_CCHPI (1,1,01-JAN-
[code]...
I have taken one non database block and my item Test which is non-database too. But no result is coming i have attached JPEG file too.
Forms :: Display Record Counts / Unique Names
Sep 25, 2012I have a table
TAB1 with data
no name
1 abc
2 abc
3 xyz
4 xyz
5 cvb
now I would like to create a form with name counts as
abc 2
xyz 2
cvb 1
I would like to create a datablock to display all the unique names, not sure where I should be writing the query to display unique names. I would like to create a textitem box to display the counts when the form is compiled, but not sure which trigger to use to write the query.
Forms :: Display Alert When Click On Insert Record In Tool Bar?
Jun 26, 2013I want to display an alert when we click on Insert Record in tool bar. I put allow update->yes and insert->no.
but when i click on the insert record in tool bar it showing message only.
Instead of message I need an alert using triggers. I added the image also.
Forms :: Display All Records One By One As User Click On Next Record Button
Jul 13, 2010I 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.
Forms :: Unable To Display A Message When Record Status Is Changed?
Jun 2, 2010I have one requirement.i.e I want to display 'Do you want to save the changes you have made?[YES/NO]' message when record status is changed.In my form if i enter some value to the actual qty(db item) and press 'x' button it does't prompting 'Do you want to save the changes you have made?' message.
For displaying this message i have written following code in the APP_CUSTOM body:
IF (wnd = 'XXMZ_MRS_DET')
THEN
lv_wnd_stat := get_window_property('XXMZ_SUMMARY',VISIBLE);
if lv_wnd_stat = 'TRUE' THEN
IF :SYSTEM.form_status = 'CHANGED' THEN
CLEAR_BLOCK(ASK_COMMIT);
ELSE
[code]....
if i write above code in the app_custom body it's prompting the above message.But if i click 'YES' it does't save the records?
How can i save the records when i click 'yes'?
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
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 RelatedSQL & PL/SQL :: Display Some Value When There Is No Record In Table
Jul 8, 2010I have a following table,
create table test ( col1 date,col2 number);
Data:
col1 Col2
----------
NULL NULL
select * from test where col2=123 will give me null because It doesnt have any values, But can we display some harcoded value when I do not have anything ?
SQL & PL/SQL :: How To Display The Duplicate Record In Table
Jun 30, 2011how to display the dupicate record in table
View 1 Replies View RelatedPL/SQL :: Only Display A Column Value One Time For A Record / Not A Static Value
Jan 7, 2013I am trying to only display a column value one time for a record, not a static value. The value changes and there can be many values. I do not think grouping will work since the Date value is dynamic. I am using Oracle for Toad 10.5. There are 4 records with this test data.
select Date, Person, Language, Country
from TableATableA
Date Person Language Country
01/25/2013 James English
12/20/2012 James English
US
[code]....
SQL & PL/SQL :: How To Display The Status And Record Count In Separate Rows
Mar 6, 2013My problem is i need to display the status and the record count in separate rows.How can i do it
Example
SELECT 'A' STAT, COUNT(A) CNT,'B' STAT, COUNT(B) CNT,'C' STAT, COUNT(C) CNT
FROM TAB1;
OUTPUT SHUD BE LIKE
STAT COUNT
A A_cnt
B B_CNT
C C_CNT
Application Express :: Message Display Before Submit To Record
Nov 5, 2012I have created two page process with two buttons "APPROVE" AND "CANCEL" button. first page process running approve invoice procedure on approve button and second page process running cancel invoice procedure on cancel button. i want to display massage before approve invoice and cancel invoice (DO you want to approve invoice) on approve button and (Do you want to cancel invoice on ) cancel button.
Working with apex4.1.
Server Utilities :: How To Associate Header Record To Its Corresponding Detail Record
May 16, 2012I am loading data file using SQL Loader in TOAD 10.5.1.3 in Oracle 10g using the control file below and loading data into 2 tables post1.thead and post1.tdetl. THEAD contains item level transaction and TDETL is detail level when a transaction has a discount or promo attached to for that item. When the
LOAD DATA
APPEND
INTO TABLE post1.thead
WHEN (1:5) = 'THEAD'
TRAILING NULLCOLS
(file_type POSITION(1:5)CHAR,
[code]....
A particular THEAD value may have 0, 1 or many TDETL corresponding values.below is a sample data file. When the position 21 in the TTAIL has a value of 1 or 2, then we know that there is a promo or discount applicable to the ITEM (THEAD).
THEAD0000000002201109142011091400000000000002091 1 0 -1
TTAIL0000000003000000
THEAD0000000012201109142011091400000000000002091 1 0 -1 20110914-1
TDETL0000000013CMPSPL1004 0 000000010000P0000000000000019990000000000000000200000
TTAIL0000000014000001
THEAD0000000021201109142011091400000000000002091 1 0 -1
TDETL0000000022EMPDSC1005 0 000
TDETL0000000023SCOUP 1006 0 973452 000
TTAIL0000000024000002
What I want to acheive is to accurately reflect a TDETL to its corresponding THEAD, as both THEAD and TDETL are loaded into separate tables. How can we have the 2 records correlated?
PL/SQL :: Selecting Single Record From Multiple Record Based On Date?
Aug 26, 2013I have a table which contains the multiple records for single ID No. Now i have to select single record which contains the latest date. here is the structure Name
Null Type ------ ---- ------------ ID_P NUMBER NAME_P VARCHAR2(12) DATE_P TIMESTAMP(6) Records---------------------1 loosi 22-AUG-13 01.27.48.000000000 PM1 nammi 26-AUG-13 01.28.10.000000000 PM2 kk 22-AUG-13 01.28.26.000000000 PM2 thej 26-AUG-13 01.28.42.000000000 PM
now i have to select below 2 rows how can write select qurie for this?
1 loosi 26-AUG-13 01.27.48.000000000 PM2 thej 26-AUG-13 01.28.42.000000000 PM
SQL & PL/SQL :: Create A Query That Returns Record By Record A Field
Apr 21, 2010I have the following case to solve:
Example Table:
Nr_ordPos1Pos2Itemqty
O4018510000107 170,00
O4018520000107 30,00
O40651010000107 500,00
O40651020000107 50,00
O4114510000107 300,00
O31141010000107 50,00
O3114520000107 50,00
I need to create a query that returns record by record a field qty_progr with the cumulate qty considering previous records. The result should be the following:
Nr_ordPos1Pos2Itemqty qty_progr
O4018510000107 170,00 170,00
O4018520000107 30,00 200,00
O40651010000107 500,00 700,00
O40651020000107 50,00 750,00
O4114510000107 300,00 1050,00
O31141010000107 50,00 1100,00
O3114520000107 50,00 1150,00
Application Express :: Display Custom Message For Report When Record Count Returned
Nov 8, 2012Our application has a homepage that displays results of several SQL statements that are defined as reports. One report in particular should only display a custom message when Count of Invoices having a particular status > 0, and not the actual invoice count itself.
I have gotten the layout to not display the count but I need to be able to display a custom message that says "Problem Invoices exist. Please see Invoices Report for more information." I've looked over the Report Attributes definition page but I cannot find how to display this custom message.
PL/SQL :: Code Erases Previous Month Record While Updating Current Month Record
May 16, 2013Using 11gR2, windows 7 client machine. I need to update the table missing_volume (below), where I need to calculate the estimated_missing column. The calculation of estimated_missing column for current month needs previous month numbers (as commented inside the code below). I want the output like the first table. Notice the records start from January, hence estimated_missing for January can't be calculated, but for the the rest of the months it can be done by simply changing 'yr' and 'mnth' (commented inside the code towards the end).
yr mnth location volume actual_missing expected_missing estimated_missing
---------------------------------------------------------------------------------------------------------------------------------
2013 January loc1 48037 24 57
2013 February loc1 47960 3660 53 24
2013 March loc1 55007 78 57 28
2013 April loc1 54345 72 58 77The code:
UPDATE missing_volume g
[Code]....
The code does calculate correct number for 'estimated_missing' as I run the code for each month, but the problem is while updating the current month it also erases the record for previous month. E.g. as can be seen below, after I updated April the column only has the record for April, previous month record is gone, similarly updating March removed February, etc. I can't understand why it's happening!! Here is the output I get:
yr mnth location volume actual_missing expected_missing estimated_missing
---------------------------------------------------------------------------------------------------------------------------------
2013 January loc1 48037 24 57
2013 February loc1 47960 3660 53
2013 March loc1 55007 78 57
2013 April loc1 54345 72 58 77
why it's happening (I mean where is the flaw in the code) and how to get the desired output (first table).
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 :: 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 :: 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 ?
Forms :: 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 Related
