----- Original Message ----- From: "Alastair Burr" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> Sent: Sunday, July 18, 2004 10:14 AM Subject: [RBG7-L] - Re: Slow combo box in form; oops forgot to change the subject
> Wow! Mike, that is fast. I think "just a couple of seconds" to load is > wildly exaggerating the time it takes. Either that or my eyes are slow > today! It was more like instant on my machine (W98SE/250mb ram/PIII - not > exactly state of the art any more.) All of my references were from the Conference examples, and I didn't optimize anything to use the local hardrive for the temporary files, so everything went through the cable. I am sure it is a bunch faster like you are experiencing. I think I will prepare a little more detailed example in a couple of days as I think many are overlooking this. I know Larry liked a nicely formatted multicolumn display and I have examples of just such (except Absent the "Show Lines" that he likes) behavior that is easy to read and pleasing to the eye... > The trouble is that it makes the speed of the dbcombobox lookup seem even > less "exciting". Obviously, that's under review for v7.5 but if R:Base can > load external data that fast you would think internal data would be even > faster. > > Out of interest, what were your reasons for the 3 buttons - top, right & > bottom - that couldn't be seen? Actually, they can be seen.. They are thin lines bordering the listbox that simply close the window. Keeping them thin and within easy mouseclick works for the lazy user (like me!) > Regards, > Alastair. > > > ----- Original Message ----- > From: "MikeB" <[EMAIL PROTECTED]> > To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> > Sent: Saturday, July 17, 2004 2:09 AM > Subject: [RBG7-L] - Re: Slow combo box in form; oops forgot to change the > subject > > > > www.byerley.net/LoadBigFile.zip > > > > An RB7 form with Listbox and simple code to load the contents of the file > called > > BigFile.LFF. Put the BigFile.LFF file in the same directory of the DB > that you > > import the RB7 Form into. > > > > The Form requires table Dummy. Just run the form and it loads 41890 > cities and > > zipcodes in just a couple of seconds. The file was created using output > to > > file, and some Formatting Functions to create the alignment of the text in > the > > listbox as shown. The Select to create the file was only a couple of > seconds, > > so the whole thing was under 5 seconds.. > > > > The Conference CD has examples of multiple columns of data aligned > correctly and > > also demonstrates using One form to perform multiple tasks by getting its > > startup information from an initialization file. >
