Most MCL functions accept an MCL condition argument. Here are 2 examples:
HrSum('HrWinTickets( )',,'For HrFP( )=1')
In the example above, the MCL condition 'For HrFP( )=1' tells RaceMate to sum the Win Investments of the horse in only in the winning starts, i.e., HrFP( )=1.
HrRating(1,'For HrFP( )=1')
In the example above, the MCL condition 'For HrFP( )=1' tells RaceMate to show the rating of the last (the first argument: 1) winning (the MCL condition: 'For HrFP( )=1') start .
An MCL condition must be quoted. You may use single quotes (' '), double quotes (" ") or square brackets ([ ]) provided that the quotes do not already exist in the condition expression.
An MCL Condition is composed of a For clause and a While clause. While RaceMate is scanning backwards to retrieve data or do statistics on past records:
|•||a For clause asks RaceMate to act on only the records that satisfies the logical condition that follows the For keyword.|
|•||a While clause causes the MCL function to stop action once the logical expression that follows the While keyword evaluates to false.|
Both For and While clauses are optional. See the topic When to use the While keyword for the difference between For and While.
The conditions specified by the For and While keyword can be compound conditions, i.e. criteria connected by And and Or, for example:
HrSum('HrWinTickets( )',,'For HrFP( )=1 And HrDistance( )=1400')
Important: If both For and While clauses exist in the condition argument, please place the For clause before the While clause.