Navigation:  MCL Reference > Data Collection Assistant Functions >

HrHistoryList( ), JrHistoryList( ), SrHistoryList( )

Print this Topic Previous pageReturn to chapter overviewNext page

The functions return a string composed of a list of items got by concatenating the values of an MCL expression in the past records of a horse. The values will be separated by commas.

 

Syntax

HrHistoryList('cValueExpr',nRaces,'fCondition' ,cIncluding,cSeparator,lRecentFirst)

JrHistoryList('cValueExpr',nRaces,'fCondition' ,cIncluding,cSeparator,lRecentFirst)

SrHistoryList('cValueExpr',nRaces,'fCondition' ,cIncluding,cSeparator,lRecentFirst)

 

Argument

Description

Example

'cValueExpr'

Expression returning the target datum.
lCountIf can be of any data type. If lCountIf is of logical type, all true (.T.) values will be counted. For any other types, record will be counted only if lCountIf returns a non-null value.

'HrFP( )'

nRaces

Number of latest races, counting back from the underlying race, to be averaged. The races must be meeting the condition specified by 'fCondition'.
If nRaces is omitted, all races meeting 'fCondition' will be included.
If total number of races meeting 'fCondition' is smaller than nRaces, the function will perform calculations on only the available races. You may use the HrCount( ) function to check how many races have been counted.

4

'fCondition'

If argument 'fCondition' is passed, the races (nRaces) will only be selected from those meeting 'fCondition'. The 'fCondition' argument is composed of a For clause and a While clause.
A For clause causes the function to act on each record that meets the specified logical condition.
A While clause causes the function to stop action once the logical expression evaluates to false.
Both For and While clauses are optional.

'For '+Same(HrDistance( ))

cIncluding

When applying the function to past records, by default, races in the underlying meeting are not included. You may use this argument to change the scope. See the following page for details: The cIncluding Argument.

'R'

cSeparator

Separator, which is default to ","

"-"

lRecentFirst

If .T., lastest items will be put first. (Recent items are put to the right by default)

.T.

 

Returns

Character

 

Example

HrHistoryList('HrFP( )',4)

Finishing positions of last 4 starts. (Example returned string: "2, 3, 9, 1")

 

HrHistoryList('HrFP( )',4,'For '+Same('HrDistance( )'))

Finishing positions of last 4 starts of distance same as the current start. (Example returned string: "2, 3, 9, 1")

 

HrHistoryList('HrFP( )',4,'For '+Same('HrDistance( )'),,'-',.T.)

Finishing positions of last 4 starts of distance same as the current start. Latest finishing positions will be put first (Example returned string: "2, 3, 9, 1")

 

 


Page url: http://www.racematenet.com/english/help/index.html?hrhistorylist.htm