Home » Developer & Programmer » Application Express & MOD_PLSQL » How to keep ID throughout wizard (Application Express, 4.0, windows 7)
How to keep ID throughout wizard [message #533271] Tue, 29 November 2011 02:55 Go to next message
abarnybox
Messages: 49
Registered: November 2011
Member
Hi,

What I want to do is keep a generated ID throughout a wizard. So on the first page they fill in their personal detials and an ID is created with that form to that table in the database. Then on the second form the ID that is generated is kept in memory and put into the person_ID column on the next form. Then they fill out the request and another ID is generated with that form to that table in the database. Then on the last page a report of both forms using the IDs generated.
Presumably this is possible, I hope you understood what I am asking. Thanks in advance for your help.

abarnybox
Re: How to keep ID throughout wizard [message #533272 is a reply to message #533271] Tue, 29 November 2011 02:57 Go to previous messageGo to next message
abarnybox
Messages: 49
Registered: November 2011
Member
Actually reading through that I realised I could use just the ID from the 'Request' form to create the report cos the personal details ID would be linked to that request anyway.
Does that make it easier?
Re: How to keep ID throughout wizard [message #533280 is a reply to message #533272] Tue, 29 November 2011 03:33 Go to previous messageGo to next message
Littlefoot
Messages: 19653
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Quote:
keep a generated ID throughout a wizard

Well, maybe "Application item" or "Page 0 item" might be options here.
Re: How to keep ID throughout wizard [message #533284 is a reply to message #533280] Tue, 29 November 2011 03:49 Go to previous messageGo to next message
abarnybox
Messages: 49
Registered: November 2011
Member
How do I do that?
Re: How to keep ID throughout wizard [message #533314 is a reply to message #533271] Tue, 29 November 2011 07:26 Go to previous messageGo to next message
dr.s.raghunathan
Messages: 540
Registered: February 2008
Senior Member
As LF said the multiple page item can be assigned values from the current page item like p1_item_id := &p2_item_id.

Generally omission part is period followed by second page item. If you use the wizard for assignment, this type of error will not occur. In a page item, you shall visualise the wizard through screw icon. If assignment done through wizard, the values will reside throughout the session until it is changed through some other source.
Re: How to keep ID throughout wizard [message #533316 is a reply to message #533314] Tue, 29 November 2011 07:28 Go to previous messageGo to next message
dr.s.raghunathan
Messages: 540
Registered: February 2008
Senior Member
#message 533272 is also the solution
Re: How to keep ID throughout wizard [message #533322 is a reply to message #533316] Tue, 29 November 2011 07:52 Go to previous message
abarnybox
Messages: 49
Registered: November 2011
Member
I'm sorry I didn't really understand that...
whats the multiple page item? page 0?

[Updated on: Tue, 29 November 2011 07:53]

Report message to a moderator

Previous Topic: Help with form conditions
Next Topic: log in with cookies
Goto Forum:
  


Current Time: Thu Oct 02 12:23:32 CDT 2014

Total time taken to generate the page: 0.08536 seconds