Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #9557
| From | Martin <Martin@spam.spam> |
|---|---|
| Newsgroups | comp.lang.clipper.visual-objects |
| Subject | Re: BBrowser question |
| Date | 2016-07-26 17:12 +0100 |
| Organization | A noiseless patient Spider |
| Message-ID | <nn824j$c45$2@dont-email.me> (permalink) |
| References | <nn548s$qvg$1@dont-email.me> <nn55oq$150$1@dont-email.me> |
Using ADS And already about 40 indexes On 25/07/2016 14:55, Johan Nel wrote: > Martin, > > On 2016/07/25 15:30, Martin wrote: >> Had a request from a customer. >> >> Can we reverse a browse so the largest key value is at the top rather >> than bottom? >> >> All I can find is that is follow the current order of the file. But >> they want it reversed. >> >> Newest at top. >> >> Any ideas please? > Do they want at runtime(1) to do it, or is it fixed(2)? What is the > database [SQL(3)/DBF(4)] that the data is stored in? > > Depending your answer: > > 1. This depends on 3/4. > > 2. Again depends on 3/4. > > 3. If 1 then refesh from SQL with correct ORDER BY clause, (somebody > need to maybe comment on this one since it is ages since I last worked > on VO and bBrowser), not sure if it is possible with > VO2ADO/SqlSelect/SqlTable to change the ORDER BY on the in memory > "Server/Table". If 2 then ensure your ORDER BY brings the rows back in > DESC order. > > 4. Create a Descending index on the DB, does not matter then if you > answered yes to 1 or 2. Just set order to preferred order and refresh > the browser if answer is 1. > > HTH, > > -- > *Johan Nel* > George, South Africa > > > <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient> > Virus-free. www.avast.com > <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient> > >
Back to comp.lang.clipper.visual-objects | Previous | Next — Previous in thread | Find similar | Unroll thread
BBrowser question Martin <Martin@spam.spam> - 2016-07-25 14:30 +0100
Re: BBrowser question "Wolfgang Riedmann" <wriedmann@gmail.com> - 2016-07-25 17:34 +0200
Re: BBrowser question sherlocksoftware@gmail.com - 2016-07-26 03:30 -0700
Re: BBrowser question Martin <Martin@spam.spam> - 2016-07-26 17:12 +0100
Re: BBrowser question "Wolfgang Riedmann" <wriedmann@gmail.com> - 2016-07-26 21:22 +0200
Re: BBrowser question Martin <Martin@spam.spam> - 2016-07-27 16:06 +0100
Re: BBrowser question Martin <Martin@spam.spam> - 2016-07-26 17:12 +0100
csiph-web