Ask Question
Help Others
Home › Forums › PeopleSoft › PeopleSoft Technical

You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

component prebuild question

3 replies [Last post]
Fri, 03/23/2012 - 5:21pm
Guest's picture
Guest

in self service, I navigate Self Service >>> Degree Progress/Graduation >>> My Academic Requirements

there is no user interruption....but I need to insert into a table before the component pre-build is complete and the page is displayed.
I get no insert/updates allowed in prebuild. I tried to "call app engine".....but get "sql update occured...." error.

Is there a way that I can trick the prebuild.....OR....perform my select/insert PRIOR to the prebuild firing?

thanks for any suggestions.

Bookmark/Search this post with
  • Buzz Up!
  • del.icio.us
  • Digg
  • Facebook
  • Google Buzz
  • Reddit
  • StumbleUpon
  • Technorati
  • Twitter
  • Yahoo
Top
  • Login to post comments
  • 3712 reads
Sun, 03/25/2012 - 1:43am
#1
Ashar's picture
Ashar
User offline. Last seen 3 years 17 weeks ago. Offline
Joined: 03/26/2008
Posts: 227
Re: component prebuild question

I think you cannot issue SQLs in PreBuild. Have you tried Page Activate?

Top
Sun, 03/25/2012 - 10:18am
#2
Guest's picture
Guest (not verified)
Re: component prebuild question

yes, I understand db updates are not allowed. the component has a few pages. the page to be displayed is dependent on the flow (reading the tbl I want to insert) of the comp prebuild pcode. lacking data in the tbl in question, the logic steers the user to a generic page within the component. I am now considering placing a pushbutton on that generic page where I'd perform the inserts.

But I'm still interested in other options. thanks.

Top
Mon, 03/26/2012 - 4:26am
#3
Muthukumar's picture
Muthukumar (not verified)
Re: component prebuild question

1) Have a CI - built for this purpose. On page activate, instantiate the CI, assign attributes and call CI's Save() method.
2) (Disgusting option) - create a local to local routing - send a message on page activate to local node. Subscribe and write code in the onNotify of subscription handler to perform the inserts.

Top