M
Mark
Hi - when working with datasets, is it quicker to loop through the
dataset, comparing some column values with predetermined values, or
should I apply a filter on the dataset to retrieve the values I want?
(background - I'm populating an appointment calendar for consultants,
and need to check around 30 dates at a time dates for each of the 45
consultants - so I retrieve all appointments between the start date, and
the startdate + 30 days - into the dataset - I then need to find out if
a consultant has an appointment on any date in the range, and then loop
onto the next date, and then the next consultant, and populate a table
with all of this info at once).
Thanks for any guidance,
Mark
dataset, comparing some column values with predetermined values, or
should I apply a filter on the dataset to retrieve the values I want?
(background - I'm populating an appointment calendar for consultants,
and need to check around 30 dates at a time dates for each of the 45
consultants - so I retrieve all appointments between the start date, and
the startdate + 30 days - into the dataset - I then need to find out if
a consultant has an appointment on any date in the range, and then loop
onto the next date, and then the next consultant, and populate a table
with all of this info at once).
Thanks for any guidance,
Mark