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