Subject | HDR and SQLWhereItems again |
---|---|
Author | guido.klapperich@t-online.de |
Post date | 2002-02-21T08:04:20Z |
I have a Products-Table and a query on this table, a checkbox cbBundles
and in the OnClick-Event I do:
ib_query1.invalidateSQL;
ib_query1.refresh;
In the OnPrepare-Event of ib_query1 I do the following:
if cbBundles.checked then
ib_query1.sqlwhereitems.add('PCBUNDLE<>0');
So I can filter only the Bundles of my Products. When I use no HDR all
works fine, but with HDR happens something strange:
When ib_query1 is on the first record and I click on the checkbox, I get
all bundles, that's ok.
When ib_query1 is on the last record and I click on the checkbox, I get
an empty result.
Guido
and in the OnClick-Event I do:
ib_query1.invalidateSQL;
ib_query1.refresh;
In the OnPrepare-Event of ib_query1 I do the following:
if cbBundles.checked then
ib_query1.sqlwhereitems.add('PCBUNDLE<>0');
So I can filter only the Bundles of my Products. When I use no HDR all
works fine, but with HDR happens something strange:
When ib_query1 is on the first record and I click on the checkbox, I get
all bundles, that's ok.
When ib_query1 is on the last record and I click on the checkbox, I get
an empty result.
Guido