At 05:28 PM 11/9/2009, Diane DeMers <[email protected]> wrote:
Has anyone had good experiences using a Variable Lookup List View on a large table (say over 30,000 records) doing a multi-select? When I create a Variable Lookup List View control on a form for a large table, it can take 3 or more minutes to display the table when the form is initially opened. Is the Variable Lookup List View just meant for smaller tables or queries/filters that effectively limit the number of records displayed when the form is opened?
Diane, Bringing up over 30,000 records up-front without a WHERE clause in a ListView is probably not a good idea. The best approach to take advantage of Variable Lookup List View would be to use a dynamic WHERE clause that will only bring up the matching records. Then you can do what you need to do including the option to Multi-Select list item(s). In a situation like yours, the startup Variable Lookup ListView screen should be an empty list to start with. After typing a keyword or defining the selection criteria, you can dynamically build a WHERE clause that will populate (REFRESHLIST) the matching items in the list. To understand these techniques, take a look at your 2009 SAT Sample Applications, specifically the following: http://www.RUpdates.com/SAT2009_RBG9/ 01. Designing Search Screens using OnKeyPress Option (List View) 02. Managing ListBox and ListView Items 03. Using Images in ListView Controls 04. Using Multi-Select Variable Lookup ListViews 05. Cascading ListViews Hope that helps! Very Best R:egards, Razzak.
