>>>>>I have table with order set in Data Environment.
>>>>>
>>>>>When I put CLOSE INDEXES on that table it closes structural index on that table.
>>>>>
>>>>>Why is that happening?
>>>>>In Help stands that it doesn't close indexes opened with table.
>>>>>
>>>>>I have checked with ORDER() function before and after CLOSE INDEXES.
>>>>>Before ORDER() it returns order but after CLOSE INDEXES it returns empty value.
>>>>
>>>>May I ask WHY you use this command? I have NEVER used this command, I didn't even know it existed. I always use structural indexes, and if I don't need a specific order, I simply use SET ORDER TO.
>>>
>>>I have BEGIN TRANSACTION command that requires that indexes must be closed before continuing.
>>
>>As I wrote, I NEVER use IDX, I ALWAYS use cdx. I suggest that you do the same. I see no reason to use idx, since cdx is faster AND supported during transactions. I think you should see this lack of support for IDX as a clear hint!
>
>I use .idx indexes because users have needs to sort data by custom columns in table.
You can use cdx also for temp indexes.
Index on yourfield tag yourfield of tempcdx