Too many values in member list

rbuser

We were pretty astonished to find that a simple report to generate mailing
labels using In List/Autosearch generates the following error -

"Implementation limit exceeded - too many values (more than 1500) in member
list to match against"

Be very grateful if someone could confirm that there is such a limit and if
anyone has a way of working round this limit suggestions would be gratefully
received.

Cheers
Charles Davies

digitalmetaphors

The "InList" operator is implemented by the SQL database you are using; so
the limitation is in the database, not in RB. One way to work around this
limitation is to manually generate the WHERE clause for your query using the
OR operator, for example:

WHERE customer.id = 1500 OR
customer.id = 1501 OR
customer.id = 1502...

The number of expressions in a WHERE clause should have a much higher total
limit than the InList operator.

Examples of applying AutoSearch values to TQuery or TTable data access
components are provided in:

RBuilder\Demos\AutoSearch...

Cheers,

Tom Ollar
Digital Metaphors Corporation