Primary descending index on a single math numeric field

Zoltan_Gyimesi

Zoltan_Gyimesi

Legendary Poster
Hi JDEList,

I have a little custom table with 4 fields.

The primary key of this table is based on AEXT dd item and it is descending.

There is a second index too, which is the same, but ascending.

The descending index does not work, it retrieves the records in ascending order, further the UTB also shows the records in ascending order.

I have found some issue on KG about identical indicies and descending behaviour, but it was not perfectly my issue.

I deleted the secondary index, deleted the 6 well known spec file and regenerate the table with the single primary index, but the situation is the same. It works as ascending.

Does anybody know about such issue?

Any information, help will be highly appreciated!

Regards,

Zoltán
 
P80010 Browse Table Defintion application shows this index also as descending.

Regards,

Zoltán
 
Just some other information:

Records inserted / updated to this custom table using a simple headerless/detail custom form.

Access brings up the records also in ascending order.

Wether is it a primary key issue, a math numeric issue or both?

Regards,

Zoltán
 
Back
Top