Show Contents List
Summary
FRM085 - Update from a Grid
Important Observations
- This application is a simple form which is designed to extend your RDML/RDMLX knowledge. It is not intended to represent the best user interface for this type of "header and detail" update.
- SELECT_SQL can be used to create powerful and flexible search logic for reading files.
- Group boxes enable related data and objects to be visually grouped on the form
- A grid component can have input capable columns and may be processed to handle update, delete and insert to the related file.
- The search by name could be easily improved by providing radio buttons or a dropdown to select search type (Like or Contains). Then add the wild card characters into search by name logic.
Tips & Techniques
- Always use interactive SQL to test your proposed logic over your database platform.
- To use SELECT_SQL effectively you need a good knowledge of SQL. See the Technical Reference guide.
- To highlight validation errors in a grid, use the UPD_ENTRY command.
What You Should Know
- How to write a simple "header/detail" update form.
- How to manipulate a cell in a grid (specific row and column).
Show Contents List