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.
- Field visualizations can be defined easily and rapidly and are then available in all Windows applications.
- 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.
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.
- To highlight validation errors in a grid, use the UPD_ENTRY command.
What You Should Know
- How to use SELECT_SQL
- How to write a simple "header/detail" update form.
- How to manipulate a cell in a grid (specific row and column).