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! > > -- > > > > > >
