>Hi Bob,
>Thanks for the help. I think you misunderstand me, though. I have a table with 1.5 million records, and 12,000 of those have the last name 'SMITH', so I need all of those 12,000. Actually, this search has the potential to be even larger, as the user *could* enter only 'SM', which would generate an even larger list. But I can't limit the # of chars because there are 2-digit last names.
>Mark
>
Hi Mark-
The Advanced Options menu in the View Designer has an area that allows you to limit the size of your result set to a specific number of MAX RECORDS. You could create a parameterized remote view as show earlier then check _TALLY for the number of matches. If this equalled your predetermined MAX RECORDS, alert the user to be more specific and reissue the query.
If your users are at all like mine, I am sure they would not want to scroll through a list of over a hundred or so names.
Mike
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only