Hi All, I have a few numeric fields in my form. I want to display "null" in those fields when they do not contain a value in the db i.e. whenever the fields are left blank they should display "Null" in the form but will have a Null value in the db. Any idea on how to do this? Thanks.
Advertisement
Replay
Personally I'd have a WHEN-VALIDATE-ITEM trigger on the display items, and once the value had passed any validation I would update the database item accordingly (i.e. set db_field to TO_NUMBER(display_field) unless it's 'NULL' then set it to null). That way forms knows that the record has changed.
My form has 2 fields named Total_1 and Total_2. If one of the fields does not equal the other, a hidden field will display a message in red on the form alerting the user. Otherwise, the message does not display. Looks like a validation script but I w
I need show a numeric field in some reports with color red and italic font, but only when the value of number is low than zero. In another case the text must be normal. Is really possible do that? That applies to section details or final summaries. M
In the Oracle Projects Create Project screen, I've been asked to add a new LOV for Organization (LOV copied from a subsequent page) - and then pass the selected value to the next page and default in the value based on the selection on the first page.
Hey, I am using a program to retrieve data from a machine and outputting it in xml to the localhost. On a seperate computer, I am trying to create a client application to read the xml data from that IP host and just output the important values inste
Hello Experts! I need help with outputting a report that caculate the cost base on the quantities from 1 to 100 ( SummaryOfCost = QtyCost * Qty ). I have tried to implement this with an array but always get "A subscript must be between 1 and the si
Hello all, I am using Jdev 11g. I have a form page which has two inputText attributes The first one implements a valueChangeListener feature. When the user enters a value in the first field, a backing bean function will be invoked through the valueCh
hi, how to read the particilar record and display it in a popup screen when u select it using checkbox and then press 'DISP' button in alv(normal alv not with oops concepts). like i select a row which is checked (checkbox) it and i have to rea
I revised a report to have a new column. So I added this new field to the code. I see the field and the value when I call CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY' Bbut the field I added does not display. Thank-you.Hi, Please ensure that you added the r
Dear JHeadstart Team, During my work with lov I encountered another problem. I defined a lov and attached the lov to a numeric field and check the LOV for validation. Now when I use LOV using the LOV button it works fine but when I enter some numbers
I have written a SQL Server Reporting Services custom function as a C# assembly DLL and added it to my report. The purpose of the function is to search for outlier records in a collection of data. The data is represented as an array of floating point
Hi, My ALV has a quantity field. The requirement is for the first time displaying the value of this column always blank but once user change it to 0, it should keep 0 value. I implemented the first requirement by setting the property Display Leading
I need to create a image using some numeric values and i want to display values in image, Numeric values be enterd by text file, excel file or user input by dialog box, this is the sample if image. http://s17.postimg.org/5xvtzbztn/5_01_03_I.png 128 x
A .csv file contains a numeric field which in some rows contains an 11-digit number (like 14024583126). These will not display (blank or null). Some of the rows contain numbers of 5-digits or 7-digits and these display fine. How can I get the 11-d
Hi Tech-Gurus, I want to display values of a single field ( which is in a table region) in multiple rows and also need to restrict the values from decimal number. If i click save, then it will throw exception "Decimal not allowed". xxxxxx yyyyyy
Hi all, I am using jdeveloper 11.1.1.6.0 Page: my page jsff page contains one ADF table and one textbox DB: i have two database tables A & B , i need 2 columns from each table . say (A.product_no ,A.product_name,B.prodeuct_price ,B.confirm) here prod
Hi, I am new to Adobe Life Cycle.... and i am working on the following requirement and XML file is enclosed... 1. Need to validate the XML value of <pp> with condition 2. Basing on the value of <pp>, need to display the <ct> values in te
on newform.aspx just above the top of cancel button I want to put 1 hyperlink "Help" but I want to do this by script/jquery by reading my configuration list where 1 column is TITLE and other is- URL in TITLE column will write "Help" an
hi folks, I am binding a table in the context which has some numeric fields. I'm displaying the same table which has some records for editing purpose. But the problem is that the numeric field column is being displayed with zeros if it doesnot
Hi. Sorry for my broken English. I have a problem with pop-up dynamic LOV. I have a simple form called Form A containing item_code and item_name. Users can create, update and delete new item by using this form. Another form called Form B has a field