Home » Developer & Programmer » Application Express & MOD_PLSQL » Computation (APEX 4.0.2)
icon5.gif  Computation [message #559596] Wed, 04 July 2012 11:38 Go to next message
dannyperro
Messages: 2
Registered: July 2012
Location: Ecuador
Junior Member
Hi Oracle Forums

My oracle Version is Oracle Express Aplication 11g 2.0.2.0
With APEX 4.0.2

Aplication Link:
Erase (*) thats the link
*h*t*t*p*:*//*apex*.oracle*.com*/pls/apex/f?p=28841:1

TAB: PQR

Page 10
:P10_ITEM1 ---> Claim

Page 12
:P12_ITEM1 ----> Preview of Claim of Page 10 -> P10_ITEM1

I create this computation in Page 12
Before Header

DECLARE
AUX VARCHAR(5000);

BEGIN
AUX:=:P10_ITEM1;
:P12_ITEM1 := AUX;
END;
The problem is when I click in NEXT to page 12 What I had written in the text area in the 10 :P10_ITEM1 disappears.
I Delete the Computation and No problem.
I donĀ“t understand what happen.

I will be grateful for your help.

Danny Lima
Datasierra CRM
Re: Computation [message #559603 is a reply to message #559596] Wed, 04 July 2012 15:51 Go to previous messageGo to next message
Littlefoot
Messages: 18822
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
It is kind of difficult to guess. I suppose that it would be easier if you let us see your application as developers.

Therefore, just a few general objections.

I don't think that you need a computation to transfer a value from one page item to another page item. Open P12_ITEM1's properties, go to "Source" and set:
- Source used: Always, replacing ... (or Only when current value in session state is null - your choice)
- Source type: Item
- Source value: P10_ITEM1

Another option is to set "Next" button's and see its "Action when button clicked" and set
- Set these items: P12_ITEM1
- With these values: &P10_ITEM1.
Note "with these values" syntax: ampersand + item name + full stop (&P10_ITEM1.)

Why is P10_ITEM1 emptied? Check its "Source used" property. What is it set to? Did you set its default value (to NULL, possibly)?

[Updated on: Wed, 04 July 2012 15:54]

Report message to a moderator

Re: Computation [message #559608 is a reply to message #559603] Wed, 04 July 2012 18:17 Go to previous message
dannyperro
Messages: 2
Registered: July 2012
Location: Ecuador
Junior Member
Hi littlefoot

Thanks a lot, your tips help me to fix the problem. The solution is "SOURCE" in P12_ITEM1's properties.

Danny Lima
Ecuador.
Previous Topic: APEX Error !
Next Topic: Put Values On Web-Page
Goto Forum:
  


Current Time: Wed Apr 16 21:57:01 CDT 2014

Total time taken to generate the page: 0.08669 seconds