I am having trouble getting Infopower's TwwDBLookupCombo working consistently with ElevateDB.

I have seen a number of posts regarding Infopower and DBISAM but no regarding ElevateDB.
Is anyone using TwwDBLookupCombo successfully with ElevateDB?

Richard Harding

Richard,

<< I am having trouble getting Infopower's TwwDBLookupCombo working
consistently with ElevateDB. >>

What in particular is giving you problems ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Hi Tim,

The TwwDBLookupCombo drop down list frequently has duplicated items.

For example, populating the drop down list with items from a Job Category table may result
in the following items appearing.

. Solicitor
. Accountant
. Accountant
. Photographer
. Teacher

OR

. Solicitor
. Accountant
. Photographer
. Solicitor
. Accountant
. Photographer
. Teacher

Assigning the lookup table to a Query with an ORDER clause appears to works OK.

The another issue that I cannot duplicate is:

.  sometimes the TwwDBLookupCombo controls complain (I cannot duplicate, so I cannot tell
you the error message) if instead of selecting an item from the drop down list, I click
outside the list.

Richard Harding

Richard,

<< The TwwDBLookupCombo drop down list frequently has duplicated items. >>

Can you send me an example of this along with the database catalog and
table(s) ?

Thanks,

--
Tim Young
Elevate Software
www.elevatesoft.com

Richard,

<< The TwwDBLookupCombo drop down list frequently has duplicated items. >>

I checked out your project in the Binaries newsgroup, and the issue is
simply one of ordering - you need to make sure that the lookup field is an
indexed field, or else you will get weird results because the Locate will
have to use a table row scan instead, which is not ordered.  The order of
the rows on disk will not necessarily match the natural order of the rows
that you see in a table without a primary key or any indexes.

--
Tim Young
Elevate Software
www.elevatesoft.com

>>You need to make sure that the lookup field is an
indexed field.

Thank you . . . . .  You would not believe how long I spent trying to work that one out .
. . .


Richard Harding

Richard Harding <rharding@wck.com.au> wrote:

I am having trouble getting Infopower's TwwDBLookupCombo working consistently with ElevateDB.

I have seen a number of posts regarding Infopower and DBISAM but no regarding ElevateDB.
Is anyone using TwwDBLookupCombo successfully with ElevateDB?

Richard Harding