Numeric fields and display values

Advertisement
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.

How to compare two currency form fields and display a message if the fields do not equal?

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

Change the style of a numeric field when his value is 0

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

Adding New Field and Passing Values Between Screens

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.

Retrieving data from TCP/IP in xml and displaying values?

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

Store and display value in array

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

How to assign and display an attribute value from backing bean?

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

Reading the record and displaying when u select it using checkbox

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

New ALV Grid Field not Displaying?

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

Using LOV with Validation on the Numeric Fields results in Error

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

SSRS - Pass Field Value List To Custom Function Assembly And Display Result

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

ALV: Quantity field displays both blank and 0 value.

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,

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

Large numeric field in a .csv file will not display

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

Display values of a single field in a multiple rows in a table region

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

How to add the values of all selected columns in a table and display it ?

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

Validate the XML tag value and display the Binding data in XDP

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

How to read list item and display Title and on click hyperlink as value by javascript /jquery

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

Displaying no default zeroes for the numeric field in the table display.

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

LOV problem ... returning display-value and not key-value

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