Oracle Consulting Oracle Training Oracle Support Development
Oracle Books
SQL Server Books
IT Books
Job Interview Books
Rampant Horse Books
911 Series
Pedagogue Books

Oracle Software
Write for Rampant
Publish with Rampant
Rampant News
Rampant Authors
Rampant Staff
Oracle News
Oracle Forum
Oracle Tips
Articles by our Authors
Press Releases
SQL Server Books

Oracle 11g Books

Oracle tuning

Oracle training

Oracle support

Remote Oracle


Privacy Policy




Oracle Tips by Burleson 

Text Fields

Text items are the most basic and most commonly used items in HTML DB.  They are the item used for entry and display of values to and from the user.  There have been many examples of text items already in this chapter, for example, the First Name and Last Name items of Figure 10.33 are text items.

A Text field is used for the normal data entry from the user.  It will accept any characters typed into it and will save the value to the session state when the page is submitted.  The values then can be inserted into the database or used in any other fashion during processing.  There can be up to a maximum of 30,000 characters entered into a text field.

There are a few different types of Text items:

  •  Text Field:  This type renders as a text field.  The value entered into the text field will be saved in the session state when the page is submitted.

  • Text Field (Disabled, does not save state):  This type of text field is read only.  The user will not be able to type into the field.  It will display the value of the item in a subdued color, grayed out.  The value will not be saved to the session state upon page submission.

  • Text Field (Disable, saves state):  This type of text field is much like the Text Field (Disabled, does not save state) but as the name implies, it does save the value to the session state upon page submission.  The value display will be more normal.

  • Text Field (always submits page when Enter pressed):  This type is the same as the normal text field.  The distinction is that if the Enter button is pressed on the keyboard, the page will automatically submit.  This is a good option to use if the goal is to let the user have quick data entry while keeping their hands on the keyboard instead of having to click a button with the mouse. 

  • Text Field with Calculator Popup:  This is another specialized version of the text field.  This field is like a normal text field, but it will have a small calculator icon next to the field.  When the icon is clicked, a calculator will popup.  The user can use the calculator to compute a value.  When Done, the value will be copied into the field.  Figure 10.34 shows the field with the calculator popup.

The above book excerpt is from:

Easy HTML-DB Oracle Application Express

Create Dynamic Web Pages with OAE

ISBN 0-9761573-1-4   

Michael Cunningham & Kent Crotty


Download your Oracle scripts now:

The definitive Oracle Script collection for every Oracle professional DBA

Linux Oracle commands syntax poster

ION Oracle tuning software

Oracle data dictionary reference poster

Oracle Forum

BC Oracle consulting support training

BC remote Oracle DBA   



 Copyright © 1996 -2017 by Burleson. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation. SQL Server® is the registered trademark of Microsoft Corporation. 
Many of the designations used by computer vendors to distinguish their products are claimed as Trademarks