Summary

Important Observations

• GROUP_BY's define a set of fields and simplify your code and reduce future maintenance effort.

• Messages from the Server Module are routed to a messages collection in the Sys_MsgQ component running in the browser. The web page application can access sys_msgq.messages in a FOR/ENDFOR loop.

• The Sys_Web component interfaces with the web browser.

• The Pop Up control is an easy to implement reusable part, which can be used by your web page application.

Tips and Techniques

• Always use the Command Assistant with commands such as a Group_By which require a list of field names.

What You Should Know

• How to write a simple add record web page.

• How to create a Server Module.

• How a web page executes a srvroutine to access a database.

• How the Group_By statement is used.

• How to use the FETCH and INSERT database commands