Summary
In this module, you learned how to retrieve data from the database and
how to use the Get function to retrieve a record by its primary key.
Use FindFirst and FindLast when you need only the first or last
record. Use Find('-') or Find('+') when you might stop reading before
processing all records. If you only want to check whether a record exists,
you can use the IsEmpty function.
To retrieve a dataset, use the FindSet function. You can use a
repeat until statement to loop over the records. Therefore, you need
the Next statement to complete the task.
You learned how to sort with the SetCurrentKey function and filter
with the SetRange and SetFilter functions. The SetRange function
can be used to filter with a start and an end value, while the SetFilter
can be used to search with the >, <, & and | signs.
If you don't specify a start value for the SetRange, you remove
the filter on that field.
To manipulate data, you can use the Insert, Modify, ModifyAll,
Delete, and DeleteAll statements. Before you insert data, you should
use the Init function to initialize default values for non-primary-key
fields. These statements by default don't run the triggers that are defined in the
table. You need to specify the RunTrigger parameter and then set it to
true. A Modify or a Delete action happens without warning.
Additionally, you discovered important field functions. By default,
FlowFields aren't calculated in code; you need to use the
CalcFields function on FlowFields.
The OnValidate trigger isn't run when you assign a value to a
field, but you can use the Validate function to run the OnValidate
trigger or use the Validate function to assign and run in one
statement.