void = Reset_FindNextHolidayOnDate()

 

This macro function moves the holidays table cursor back to the beginning of the table, and prepares its index for subsequent calls to the function FindNextHolidayOnDate.

 

➢Independent search positions: the 2 groups of macro functions, FindNextHolidayOnDate / Reset_FindNextHolidayOnDate and GetNextDateForHolidayId / Reset_GetNextDateForHolidayId, use separate cursors to access the same holidays data. Each reset function resets only the cursor used by its corresponding search function. Consequently, macros can contains loops, mixing these groups of functions without losing the outer loop’s search position.

 

Below is an example of the use of the function FindNextHolidayOnDate to iterate over all the holidays of nHolSetID on nDate.

// get all the holidays of nHolSetID on nDate
sRESULT = ''
// move the table's cursor back to the beginning
Reset_FindNextHolidayOnDate()
// look for all holidays on same date
while FindNextHolidayOnDate(nDate,nHolSetID)
   sRESULT = sRESULT + chr(13) + GetHolNameFromTable()
endwhile

See also: FindNextHolidayOnDate and Reset_GetNextDateForHolidayId.

 

---

Topic 110052, last updated on 11-Oct-2026