Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Pass value of Item in page101 to anather pages
Pass value of Item in page101 to anather pages [message #399729] Thu, 23 April 2009 14:41 Go to next message
tamalkhalidi
Messages: 5
Registered: April 2009
Junior Member
Hi
I havee Access page with custom authintication ,including password/user name/and site items
I want to pass the site value during all the pages in the application
The site item in 101 page as select list.

Thank you
Tamara
Re: Pass value of Item in page101 to anather pages [message #399733 is a reply to message #399729] Thu, 23 April 2009 15:11 Go to previous messageGo to next message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
Assuming your page 101 is submitted, the "site" item's value will have it's state saved, so you should be able to simply refer to that item from other pages to retrieve it's value. This assumes that the item's properties as set to save state (the default).
Re: Pass value of Item in page101 to anather pages [message #399735 is a reply to message #399733] Thu, 23 April 2009 15:41 Go to previous messageGo to next message
tamalkhalidi
Messages: 5
Registered: April 2009
Junior Member
Hi ,
But my Site item is Select List :-there is no save state for select list.
Thank you
Re: Pass value of Item in page101 to anather pages [message #399742 is a reply to message #399735] Thu, 23 April 2009 20:18 Go to previous messageGo to next message
dr.s.raghunathan
Messages: 540
Registered: February 2008
Senior Member
still it is very easy since it is an another select list consists static values and generally will be defined under shared compononents. Hence i could not understand the difficulty in sharing select list items on multiple pages
Re: Pass value of Item in page101 to anather pages [message #399743 is a reply to message #399742] Thu, 23 April 2009 20:37 Go to previous messageGo to next message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
My select lists are definitely stateful even if it doesn't explicitly say that in the item type list. On your item details page, under Source, you'll see Maintain session state by Session or User. When running in developer mode, you can see item values using the "session" link at the bottom of the page.

If a select list retains your previously selected value when the page refreshes this it's using the state of the item to do that.
Re: Pass value of Item in page101 to another pages [message #399932 is a reply to message #399743] Fri, 24 April 2009 10:16 Go to previous messageGo to next message
tamalkhalidi
Messages: 5
Registered: April 2009
Junior Member
Hi,
Thank you so much for replay me again,
To explain more,
I have site item type: "select list"
item_name: "P101_Site_id"
LOV: select SITE display_value, SITE_ID return_value
from TBLSITE
order by 2
Maintain session state: Per session
In page 101


In page 7
I created item type: "text field"
item_name: "P7_Site_id"
I created Computation: Computation Point :Before Heading
Source :P101_Site_id

and still not working

Thank you again
Tamara
Re: Pass value of Item in page101 to another pages [message #399980 is a reply to message #399932] Fri, 24 April 2009 14:14 Go to previous messageGo to next message
tamalkhalidi
Messages: 5
Registered: April 2009
Junior Member
Hi,

I need to display values in items related to database.
I created tabular form with 3 items related to database.
Table (Sample_id,Sample_Number,description)
In page 7
P7-Sample_id display as hidden
p7_Sample_Number display as text
p7_discribtion display as select list

I want to add auto values to p7_Sample_Number like 'G2009_123_01',.........,'G2009_123_10'
that is mean when i press add row button in tabular form 10 rows add with default values in p7_Sample_Number .


Thank you for help
Tamara
Re: Pass value of Item in page101 to another pages [message #399997 is a reply to message #399932] Fri, 24 April 2009 21:11 Go to previous messageGo to next message
dr.s.raghunathan
Messages: 540
Registered: February 2008
Senior Member
hi,
you would have created lov under some name. It is not definitely p101_site_id since this field used the lov as select list. If my guess is right, call the created lov name in the page 7 as select list definitely you will get the return values.
Re: Pass value of Item in page101 to another pages [message #400802 is a reply to message #399997] Wed, 29 April 2009 12:24 Go to previous message
tamalkhalidi
Messages: 5
Registered: April 2009
Junior Member
Hi,
First Thank you for helping me all the time ,
I triet to create tabular form with update data only ,
On load page i delete all the data from the table and inserted for first 3 columns data to reterivet in the tabular ,
one of these 3 coulmns it is "PK" ,first coulmn.
number of rows itis fixed =10
when i need to update the tabular form this error message appeare:
Error in mru internal routine: ORA-20001: Error in MRU: row= 1, ORA-20001: ORA-20001: Current version of data in database has changed since user initiated update process. current checksum = "DD87F801181377E16169240773213B03", item checksum = "5614EF63A7050972ACB02E2B8BA1AD4B"., update "INAC"."TBLSAMPE_FORM" set "SAMPLE_ID" = :b1, "SAMPLEPOINT_ID" = :b2, "DATESAMPLED" = :b3, "SUITESCHEDULE_ID" = :b4, "MATRIX_ID" = :b5, "EQUIPTYPE_ID" = :b6, "QAQCTYPE_ID" = :b7, "RELATEDSAMPLE_ID" = :b8, "SAMPLETYPE_ID" = :b9, "SAMPLESERIES_ID" = :b10,


Previous Topic: oracle APEX
Next Topic: difficult to import application in Appex-3.2
Goto Forum:
  


Current Time: Fri Dec 02 16:52:15 CST 2016

Total time taken to generate the page: 0.15567 seconds