OraFAQ Forum: Application Express & MOD_PLSQL » How to keep ID throughout wizard

Home » Developer & Programmer » Application Express & MOD_PLSQL » How to keep ID throughout wizard (Application Express, 4.0, windows 7)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

How to keep ID throughout wizard [message #533271]

Tue, 29 November 2011 02:55

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

Report message to a moderator

Re: How to keep ID throughout wizard [message #533272 is a reply to message #533271]

Tue, 29 November 2011 02:57

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?

Report message to a moderator

Re: How to keep ID throughout wizard [message #533280 is a reply to message #533272]

Tue, 29 November 2011 03:33

Littlefoot
Messages: 17245
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.

Report message to a moderator

Re: How to keep ID throughout wizard [message #533284 is a reply to message #533280]

Tue, 29 November 2011 03:49

abarnybox
Messages: 49
Registered: November 2011

Member

How do I do that?

Report message to a moderator

Re: How to keep ID throughout wizard [message #533314 is a reply to message #533271]

Tue, 29 November 2011 07:26

dr.s.raghunathan
Messages: 539
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.

Report message to a moderator