Databases
StackOverflow2013
Postsdbo
POTrigger a process (SQL update) when leaving an APEX page
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POTrigger a process (SQL update) when leaving an APEX page
    primarykey
    data
    text
    <p>This is a very odd question but i wondered whether it was possible to trigger a process that runs an SQL UPDATE when the user leaves this specific page, either by clicking on the breadcrumb, tabs or back button?</p> <p>I did setup the process to run on the 'Back' button; however i ran into the problem of: What if s/he clicks on the breadcrumb or a tab instead.</p> <p>I have searched the net and posting this question was a last resort. I wondered if anyone can point me in the correct direction?</p> <p><strong>UPDATED POST</strong> </p> <p><strong>Page 1:</strong><br> Includes a text field and a button. The user enters the category into the text field and clicks on the button to proceed to the next page. The button passes the value in the text field to a text field on Page 2.</p> <p><strong>Page 2:</strong><br> Two regions on the page. One region holds information about the category - Category name from the previous page, category description, and the category revision number (which is what i'm trying to get working). The second region is a report that pulls the item name and number that are listed under the category in the category text field. A 'View' link is used on the report to load the edit page for the specific item selected. The 'View' link passes the 'category name' (from the category text field) and the 'item number' from the report to page 3.</p> <p><strong>Page 3</strong><br> Two regions are used, first region: Lists the Item number which came from page 2 and name of the item (which i use a simple query to retrieve). In the second region: A report is used with two columns: a list of item properties in column 1, and a text field next to each item property in column 2 to hold the value that can be updated. The 'Apply Changes' button has some PlSql behind which looks for changes and updates where required. It updates the relevant fields that have changed, and it then takes the user back to Page 2 (Page showing user the items listed for the category intitally entered).</p> <p>I cant increase the category revision on the 'apply changes' button on page 3 because the user may complete edits for items under the same category. So i dont know where i can increase the category revision by 1 per vist to a category. P.s I already increment the revision number for each item by 1 if the info has been changed using the 'apply changes' button on page 3.</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USBlob
    1. USBlob
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POTrigger a process (SQL update) when leaving an APEX page
      1. This table or related slice is empty.
      1. VTDownMod
    2. VO
      singulars
      1. POTrigger a process (SQL update) when leaving an APEX page
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POTrigger a process (SQL update) when leaving an APEX page
      1. USMatthew Moisen
      1. VTFavorite
    1. COIf this is a data entry form, wouldn't it be better if there was a check to see if changes were made and prompt the user with that instead of firing an update?
      singulars
      1. POTrigger a process (SQL update) when leaving an APEX page
      1. USTom
    2. CO@Tom I did find a blog post about checking for changes using Javascript; however the page is only showing information, no editing is completed on the page. Actually i think it might have been your blog.
      singulars
      1. POTrigger a process (SQL update) when leaving an APEX page
      1. USBlob
    3. COWhy would you actually want to fire an update when the page (in any way) is left by the user? Does visiting the page have to trigger something special? Do they need to interact in a way? Why, if there is no entry, is it required to run some process?
      singulars
      1. POTrigger a process (SQL update) when leaving an APEX page
      1. USTom
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload