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.)
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? 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.
