Interesting solution.
So Pdox version of sql will not support create index mixed asc/desc?
Is there a reference for Pdox sql syntax?


On 12/08/2023 09:06 p.m., Kevin Zawicki wrote:
> Sometimes when I need complex dynamic sorts I use a PRIV table and link it
> to the main table, so the PRIV table is the master.
> 
> The PRIV table has the key values and a sort column (LongInt). Then a secondary
> index that is that sort column as primary.
> 
> I code filling that longint column in any sort order I need, by queries and
> sorts, then scan the sorted results filling into the sort 1...to end on the
> PRIV table master.
> 
> There are several variations for this.
> 
> 
> Peter <peterspammenot@whiteknight.email> 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.
>>>>
>