Sitemap

Amicuk Programming Answers

How to re-calculate a column value based on another column value in the same ADF Table row

2015-10-11   Views:3

Advertisement

Hi, I'm using Jdeveloper 11.1.2.3.0. I have an adf table with 2 columns, columnA and columnB. When the value changed in ColumnA, 1) i need to call a PLSQL and update the ColumnB value that is returned from PLSQL. 2) Show a warning message if the exis

Hi,
I'm using Jdeveloper 11.1.2.3.0.
I have an adf table with 2 columns, columnA and columnB.
When the value changed in ColumnA,
1) i need to call a PLSQL and update the ColumnB value that is returned from PLSQL.
2) Show a warning message if the existing value in ColumnB is different from the one that is returned from PLSQL.
Can anybody suggest how can i accomplish this?
Thanks,
Vinod

The replay answer
Advertisement
hi user,
if you have inputtext means have a valuechangelistener
in that call your pl/sql function supply input value to the appropriate function then grab the result of the function. then bind the column inputtext and compare with it. then raise your warning using FacesMessage classes.
Sameh Nassar: Create PL/SQL Function And Call It From Your ADF Application

Go to See the other 4 answers

How to re-calculate a column value based on another column value in the same ADF Table row

Category:DefaultRelease time:2015-10-11Views:130

Hi, I'm using Jdeveloper 11.1.2.3.0. I have an adf table with 2 columns, columnA and columnB. When the value changed in ColumnA, 1) i need to call a PLSQL and update the ColumnB value that is returned from PLSQL. 2) Show a warning message if the exis[More]

How to change the column name as bold in adf table

Category:DefaultRelease time:2015-10-11Views:130

Hi, How can I change the column name with bolder style and blue colour in adf Table? I changed the color and font weight in af:column properties, but its effecting the data in that column but not with the column Header Text property.(i have given col[More]

How  to retrieve a column field value from an ADF table ?

Category:DefaultRelease time:-0001-11-30Views:130

All, I have a backing bean where I have bounded a field of an ADF table. I would like, in the bean, to read the value of that field so that I can use it inside a task flow router. The question: how to read a value from a ADF table column field ? In t[More]

ADF Table cell color based on the value in that field

Category:DefaultRelease time:2015-10-11Views:130

Dear All, I want to create a table for our new application which contains a table used to represent the data in a chart format or matrix format, and each cell of the table should be filled with a colour out of three colors, based on the value belongs[More]

Can we use af:inputText + af:commandButton to render adf table column?

Category:DefaultRelease time:-0001-11-30Views:130

Can ADF table column have an inner button? Is that possible to use af:inputText + af:commandButton (custom component?) to render adf table column?user774592 wrote: Can ADF table column have an inner button? Is that possible to use af:inputText + af:c[More]

Dynamically adjust table row height based on data in column

Category:DefaultRelease time:2015-10-11Views:130

Hi all, I'm using JDeveloper 11.1.1.5.0 and have a requirement for a table to adjust the height of its rows depending on the data in the columns. One of the columns in the table is a rich text description field and I have the 'rows' property set to 1[More]

Calculate New Column in sql server

Category:DefaultRelease time:-0001-11-30Views:130

CREATE TABLE [dbo].[Table1](     [Months] [int] ,     [AccumSD] [decimal](38, 2) GO insert into [Table1]([Months],[AccumSD]) select 1    ,0.00 Union All select 2    ,21574680.03 Union All select 3    ,16706196.47 Union All select 4    ,-7873127.29 Un[More]

Script task to read the column names dynamically and create a table in database based on excel column structure

Category:DefaultRelease time:-0001-11-30Views:130

Hello, Can anyone help me out to write a vb.net script. I need to read the column names from excel and based on that column names I need to create a table in database(I have more than one sheet in excel). For each sheet columns will be changing and s[More]

Calculate the Sunday date based on 0CALDAY

Category:DefaultRelease time:-0001-11-30Views:130

Hi All, How to Calculate the Sunday date based on 0CALDAY Thanks in advance CPYuse customer exit where you can use this FM /OSP/GETDATE_WEEKDAYRead other 2 answers[More]

Need to calculate the monthly amount based to the annaul salary

Category:DefaultRelease time:-0001-11-30Views:130

Hi Expert, I need to calculate the monthly amount based to the annual salary. Some countries use a multiplier more than 12 to calculate the annual salary (e.g : 13,14 ...). My problem is to calculate the monthly increase. The increase amount is on th[More]

Issue with the last column stretching in ADF table

Category:DefaultRelease time:2015-10-11Views:130

There is an issue wherein when  I try stretching the last column of the ADF table to reduce its width it does stretch. But whenever I try stretching it back to this original position it doesn't despite having columnstretching attribute set to multipl[More]

Hot
Hello all, I am currently installing an SAP ERP 6.0 EhP4/NW7.01 Java system when I enncountered this error during the phase Create Database Statistics. Error says BR0801I BRCONNECT 7.00 (40) BR0805I Start of BRCONNECT processing: cefukrjh.sta 2011-05 [More]
I have an SSRS report based on Geographic Locations.  The datasets return project records, with a regional area, electoral area and then a city level.  I have created cascading parameters from region to electoral and then to city.  However, each proj [More]
Hai all, 11.2.2 on solaris 10 UPDATE MED_SECURITY_PRICES SET s.change_price = ((w.Prev/10)-(w.Last/10)) ,s.wa_price = ((w.AMT/(w.VOL*100))*1000) -- (DailyValue/DailyVolume)*1000 From MED_SECURITY_PRICES s JOIN stg_ws.DAILYSTKQUOTATIONDATA w ON MED_SE [More]
I had a message on my phone to do a auto upgrade, then the message said I didnt have enough battery life and it was scheduling an upgrade at 2am (this morning) now my phone will not come on!! hence uugghh!! ive plug it in to charge for 2 hours Ive ta [More]
I want to compress a PDF I have created. I've been told that in Preview, in the Print dialog box, in the PDF menu there is an option "Compress PDF." That option doesn't appear in my dropdown menu. It doesn't appear in that menu regardless of wha [More]
i m unable to install bluetooth drivers for windows 7 ultimate in macbook pro a1278. pls. send me link or guide me.Why isn't the files you put on USB that you downloaded from Boot Camp Assistant not working? That IS where you get drivers. You are tal [More]
Hi! For some time now I am trying to download the trial version but I have some problems. 1.The online page https://creative.adobe.com/products/download/aftereffects isn't loading I can see the loading symbol but it doesn't load. 2.I have downloaded [More]
Wow. A few of the admins here, myself included, had to throw the latest patch cluster onto a few of our servers. Sun is now requiring a pass code as an argument! And they've hidden the pass code in the README with the excuse that it's to get you to r [More]
Hi All, A simple query. With Cisco ios NBAR, when we say 'match protocol rtp video' , do we also match the audio embedded in the video stream ? .. or does that audio get matched only with the 'match protocol rtp audio' statement ? Also, is the 'match [More]
Hi all! I try to install the trial version of Flash CS4 on my system, but when I start the setup file, the cursor changes to the waiting icon a few seconds and then returns to normal. Nothing happens, no error report. No process running in the system [More]