Paradox Community

Items in pnews.paradox-programming

Subject:Re: SQL Create Index
Date:Sat, 9 Dec 2023 17:18:26 +1100
From:Tom Krieg <tomkIGNORE@CAPSsdassociates.com.au>
Newsgroups:pnews.paradox-programming
If it's a huge table ... why? Have you tried normalizing the table? If 
it's a reasonably sized table, extract the data to an in memory TCursor 
(fast sort) and sort that to a destination table you'll display.

On 9/12/2023 4:07 pm, Peter wrote:
> display of records
> 
> On 12/08/2023 09:04 p.m., Tom Krieg wrote:
>> That's correct. Is this for display? Or something convoluted and 
>> illogical? Have you tried extracting and sorting?
>>
>> On 9/12/2023 1:47 pm, Peter wrote:
>>> Oops, I was not clear, I need both ascending and descending in the 
>>> same index. The Index method will not allow for mixing ascending and 
>>> descending.
>>>


Copyright © 2004 thedbcommunity.com