Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Updating a table on button press

SchillersJan 29 2014 — edited Jan 31 2014

Hello,

I am trying to make a simple APEX function that allows the user to click a button on the page which corresponds to a team. I am using page processes once the button is pressed to increment the points value for the specific team by 1. An example of one of the processes is:

UPDATE teams

SET number_of_points = number_of_points + 1

WHERE team_colour = 'Blue';

This piece of SQL is executed on the page submit and when the button is pressed.

Unfortunately, no matter which button is pressed, all of the page processes are fired and all teams gain when point. How can I make it possible for the process to only effect the team for which the button corresponds to.

Thank you so much!

This post has been answered by Pars on Jan 31 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 28 2014
Added on Jan 29 2014
13 comments
498 views