Indexes and PROGRESS versions`

Raymond Gelmers

New Member
Hello all of ya!

I am Raymond, one the newer members on this site.

Today i stumbles onto a major problem:

I have a simple FOR EACH loop in an PROGRESS V8 and in a V7 environment. When I follow the sorting of a field it looks like this:

V8 V7

2002 2009
2004 2004
2006 2005
2010 2007

As you see, in V8 i have a nice ascending sorting, although this field is not part of any index in the table.

In V7 my values are scattered.
In both V7 and V8 i use exactly the same indices and the same tablesrtuctures.
It goes even further:

When in both V7 and V8 USE-INDEX is added to the FOR EACH
no difference appears!

So: both versions use EXACTLY the same index and the same data.
Why is my output different? Can PROGRESS V8 discard my own index choice as it suits?
 

Chris Kelleher

Administrator
Staff member
Originally posted by Raymond Gelmers
So: both versions use EXACTLY the same index and the same data.
Why is my output different? Can PROGRESS V8 discard my own index choice as it suits?

Well index selection rule in Progress can get pretty tricky. I would highly recommend reading this article: http://www.fast4gl.com/downloads/monographs/selection/selection.html on index selection. Also, it is usually helpful to do a COMPILE program.p XREF program.xref to generate a cross-reference for the program. This will list the index(es) that Progress has selected to use at compile time.

Hope this helps,
-Chris
 
Top