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