Subject Re: [IBO] HDR and SQLWhereItems
Author Jason Wharton
> > If you add anything that reduces the amount of records from the base
query
> > then HDR is disabled under the assumption that you are taking care of
your
> > own refinements.
> >
>
> What do you mean with my own refinements ?

If you are adding SQLWhereItems then you are adding in SQL to reduce the
amount of records your base dataset will return. Thus, your base dataset is
"refined" by your OnPrepareSQL customizations.

> >
> > What I think you should do is make an input parameter to integrate in
your
> > own refinements and this will make it so that you base query will remain
the
> > same and not trigger the HDR to become disabled.
> >
>
> Some like that 'select * from table where field=:param' ?
> But then I reduce the amount of records as well.

Yes, that is my point. But, you do it in a way that isn't recognized as a
refinement to the base query. Come to think of it, I should disable HDR when
input parameters are used for the same reason I do when SQLWhereItems is
used.

I need to add a property something to the affect of:

HDRMode: hdrmAuto, hdrmAlways, hdrmNever

How does this sound?

Regards,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com