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
Hi, i have a theoretical question: if i use R/3 Enterprise on WAS and put new Data in the R/3 System and transport them to XI with ABAP Proxies. What happens in the systems? How do the R/3 System put new data in the proxy runtime and send them to xi? [More]
How can I get my duplex printing to show up/work from the printer pop-up menu. Have installed all HP CP4005dn drivers. Installed the printer with all installable options. Printer works fine except no duplex print options. Have followed Mac Help's "Di [More]
In a scenario, i have a BPM which has a transformation step which contains a mutimapping ...means 2 messages mapped to 1 messgaes, here in the mapping i m using an UDF and written code to extract the file name from dynamic configuration..... the prob [More]
I purchased and downloaded a book in iBooks.  I read about 16 chapters.  The next time I opened the app to read the book, no words loaded on the pages.  It would go to the table of contents, but not to pages in chapters.  Any ideas?Try to reset your [More]
Hi, Can you please tell me which of the mapping is available in XI by default (among Message Mapping, ABAP mapping, Java mapping, XSLT mapping)  ? Regards, PavithraHi, The term Mapping means: 1. The transformation process, and/or 2. The transformatio [More]
I would be greatful if someone could answer any of the questions below following the description, thank you: Description: There are 3 textFields, 3buttons(add,delete,display), and 1 textArea on my applet. User types their "name" in the first tex [More]
I thought I was selecting a trial period for eHarmony but I accidentally selected a year subscription which I don't want!!! how do I get my purchase refunded?Purchases are considered final, but you can try the 'report a problem' link to contact iTune [More]
TextField_1 is visible and has limitation containing only 20 character. TextField_2 is hidden. When user will cross 20 charcter, automatically TextField_2 will be visible and cursor will go into this field. Is it possible. How can we solve it?On the [More]
It will take a couple of more days of experiments to define this problem, but I thought I would go ahead and post. I have my system (20" Alu iMac) set to sleep after an hour of inactivity and wake up at 12:30am, if needed, to execute a cron job (have [More]
Hi, I got a brand new 15" MacBook Pro a week or so back and had problems with the trackpad - when I tap to select an item the mouse pointer "bounces" off the item I'm trying to select. It happens randomly - not every time. Very irritating. [More]