I've done what Jan's suggesting. I create a temp table with an autonumber and insert data in the sorted order. Then I can grab the exact rows I want and pre-select them based on the autonumber. Are you saying you think a single-table view is faster than a temp table with an insert? I'm not sure it would be....
Karen -----Original Message----- From: Bob Thompson <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Thu, Nov 6, 2014 11:41 am Subject: [RBASE-L] - Re: Control options I was attempting to stay away from that scenario. Projecting a sorted temp table with that many rows and then obtaining an autonum value every time the control is used may become a bit slow. This is a networked app Can a single table view with an added autonum column be created? Syntax? Thanks Bob Thompson LaPorte, IN 219-363-7441 Sent from my iPod On Nov 6, 2014, at 11:20 AM, "jan johansen" <[email protected]> wrote: Bob, You can create a temp table from your master table, with an additional autonum column. Then return that column. Jan -----Original Message----- From: Bob Thompson <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Thu, 6 Nov 2014 11:16:49 -0600 Subject: [RBASE-L] - Re: Control options The variable list view was my first choice, but I am not seeing how to determine what the desired item index value would be. When I call the control, I know that I need item "x" preselected. The item number is alpha numeric field. So item "595A" may be the 632nd item in the sorted item master field. I do not see how to obtain the value 632 before calling the list control. Thanks, Bob Thompson LaPorte, IN 219-363-7441 Sent from my iPod On Nov 6, 2014, at 10:43 AM, "A. Razzak Memon" <[email protected]> wrote: > At 11:22 AM 11/6/2014, Bob Thompson wrote: > >> I need suggestions on what form control to use to select a record >> >> Requirements: >> Control must handle 2000+ records >> >> Display two columns >> >> Have a predetermine record already selected and high lighted in >> the proper list order. >> >> Display 15 records in a scrolling region >> >> Example: >> >> 123. Test >> 124. Testa >> 125 Testb >> 126. Testc >> 127. Testd >> Etc >> >> I need record 126 pre-selected/highlighted with >> the ability to select any other record in the 2000+ item list >> >> So when the control is called, it may need to start the display >> at record 900 - 915 and have the ability to scroll forward or >> backward > > Bob, > > There are so many ways to accomplish such task. > > 01. Use Enhanced DB Grid Control and then use the "JUMPTO" > property to select/highlight the record as On After Start > EEP, if you wish. > > PROPERTY TABLE <FORMTABLENAME> 'JUMPTO' > > 02. Use Variable Lookup ListView with pre-selected record value > as Key Field. > > 03. Use Variable Lookup ListView with added "Show Row Number" > with pre-selected record value as Key Field. > > Let me know if you need a sample form(s) to illustrate the use > of such cool features in R:BASE eXtreme 9.5 (32/64) for Windows. > > Feel free to reach out to me with any questions. > > Very Best R:egards, > > Razzak. > > www.rbase.com > www.facebook.com/rbase > -- > 31 years of continuous innovation! > 16 Years of R:BASE Technologies, Inc. making R:BASE what it is today! > -- > >
