CODEWITHSUNDEEP
oracle-databaseoracle-apex
McRivers
McRivers

Reputation: 373

How to Make Form w/ No underlying DB Table - APEX 19.2

Very noob question, but how can I create a form in APEX that is not based on a database table?

For example, I am looking to create a "Change Password" form that consists of 3 fields:

None of these fields will be saved to the database, so not sure how to handle the SOURCE for the underlying form. My first thought was to just use a SQL statement like this:

SELECT '' as username, 
       '' as new_pswd, 
       '' as confirm_pswd 
  FROM DUAL;

Is there a better / more APEX way to handle this?

UPDATE: I understand how to set up a process to handle the logic, but more asking what should I select for the SOURCE? It "yells" at me if I select a TYPE (TABLE/VIEW, SQL QUERY, PLSQL FUNCTION BODY...) and do not put something in there.

Thanks in advance.

Upvotes: 0

Views: 376

Answers (1)

Littlefoot
Littlefoot

Reputation: 142705

Don't use "Form" page type. Pick "Blank" instead.

Then

  • create a region on it
  • put any number of items (3 in your case)
  • create a button
  • create a process which will fire when you press that button
    • it should do "smart" things in the database - insert user into a table, change their password, whatever you plan to do

Upvotes: 2

Related Questions