James, Just after I'd replied to you I read Razzak's post about v7.5 and checked the link he gave.
That says that "fast comboboxes" will be in that version. Yippee! However, in the meantime, I said "view" not "table" for them temp data. I manage to cut the selection down to a handful of rows which is still slow but the coffee growers are laughing all the way to the bank <g>. Regards, Alastair. ----- Original Message ----- From: "james hageman" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> Sent: Friday, July 16, 2004 9:12 PM Subject: [RBG7-L] - Re: Slow combo box in form; oops forgot to change the subject > Alastair, > > Thanks, however I tried the temp table thing already and that takes too > long also. Its creating a temp table then inserting non-duplicate rows > from a table that has 14,000 records in it and that was too painfull > too > > I think I am going to have to split the table up, it will be faster and > smaller but it seems a shame cause the data is very flat. > > I just wish there was a way to have the combo box supress duplicates > for me. > > James > > > > On Jul 16, 2004, at 3:59 PM, Alastair Burr wrote: > > > The new dbcombobox is great - but for the speed. > > > > The way that I currently get around this to some degree is this: > > > > Create a temp view that you can use as the lookup in your combobox so > > that > > you can enter the columns and so on. > > > > Then, when you need to use that combobox use a command file or eep to > > delete > > and re-create the temp view with the data pre-selected however you > > need it - > > and try to minimise the number of rows returned as well. > > > > Then use this property command in an EEP before you hit the combobox: > > > > PROPERTY ID_ComboBox REFRESHLIST 'TRUE' > > > > You can create the view while in the form from a button and use data > > from > > the form to define the view. > > > > It's not perfect because you've got at least two steps but it seems to > > be > > the quickest method I've found so far. If you want more details let me > > know > > and I'll e-mail the eep & command files I use to you off-list. > > > > Regards, > > Alastair. > > > > > > ----- Original Message ----- > > From: "james hageman" <[EMAIL PROTECTED]> > > To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> > > Sent: Friday, July 16, 2004 8:09 PM > > Subject: [RBG7-L] - Slow combo box in form; oops forgot to change the > > subject > > > > > >> > >> > >>> I want to use a db combo box in a form and have the source column not > >>> show duplicate rows. How can I do this. > >>> > >>> I tried to base this on a VIEW that selected DISTINCT rows only but > >>> the form takes 35 seconds to load . > >>> > >> > >> > James Hageman, CITA I > University of Delaware Archives > 002 Pearson Hall > Newark ,DE 19702 > 302-831-3127 > [EMAIL PROTECTED] >
