Databases Reference
In-Depth Information
Figure 3-34.
The success message
Caution
The examples shown here are not complete, and they focus on single functionalities. If you want to use
the example code in your applications, you will need to complete functionality that I've omitted in order to keep the
examples simple. For example, you will need to take care of newly-added rows when updating a collection using
an On-Demand Process. The code shown here doesn't do that. However, that functionality should be fairly easy to
add.
Interesting Techniques
This section will cover some other useful techniques for working with tabular forms. These include
•
Simple Autocomplete
•
Autocomplete returning key value
•
Clone Row functionality
Simple Autocomplete
APEX 4 introduced a new item type called “Text Field with autocomplete”. Such an item is a simple
select list generated using jQuery libraries. This type of select list allows editing and shows the results as
you type. The only thing you need to do is to define a SQL query like this:
SELECT ename
FROM emp
This item type is not available for Tabular Forms. However, you can implement the same
functionality using a technique written about by Tyler Muth in his blog at
http://tylermuth.wordpress.com/2010/03/16/jquery-autocomplete-for-apex/
