Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #9557

Re: BBrowser question

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>

Show all headers | View raw


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


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