Subject | Re: [IBO] HDR and SQLWhereItems |
---|---|
Author | Jason Wharton |
Post date | 2002-01-21T20:10:13Z |
> > If you add anything that reduces the amount of records from the basequery
> > then HDR is disabled under the assumption that you are taking care ofyour
> > own refinements.If you are adding SQLWhereItems then you are adding in SQL to reduce the
> >
>
> What do you mean with my own refinements ?
amount of records your base dataset will return. Thus, your base dataset is
"refined" by your OnPrepareSQL customizations.
> >your
> > What I think you should do is make an input parameter to integrate in
> > own refinements and this will make it so that you base query will remainthe
> > same and not trigger the HDR to become disabled.Yes, that is my point. But, you do it in a way that isn't recognized as a
> >
>
> Some like that 'select * from table where field=:param' ?
> But then I reduce the amount of records as well.
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