Accessing indexed files

[Clyde_Coller_(Guest)]

Been living with extremly slow reports for a long time but believe there must be a better way.____Trying to list information from one record in an order file for a given order number. Dydacomp can access it quickly in Mail Order Manager. R&R has to search the entire file for the record that matches the order number.____Is there a way to make use of the index? ____I notice a "Use index" box for the master table but it is gray and can^t be checked even after selecting the index file____Using Infinity

[kfleming]

If you are using the CMS table as the master file, select the CMS.CDX as the master index and select the tag ORDER.__Choose the radio button Numeric as the Data Type.____Then is Starting Scope click the Start value radio button and enter the first order number that you wish to appear in the report.__This will be much faster than starting from the beginning of the table.______Kathleen__R&R Support

[Clyde_Coller_(Guest)]

We have been setting the starting value as you describe but thought it was record numnber. Since the file is in order # sequence I guess order and record numbers are equivalent. However, it is still slow if you need the flexibility to access a large range of order numbers. Also, these are moving targets as time progresses and require updating the starting point periodicaly.____I was hoping there was a way for R&R to go directly to the order record using the index.____Guess not.

[kfleming]

It would be record number if you had not selected a master index. By select the index and the tag for order number, the scope is indeed the order number which is not the equivalent of the record number.____Kathleen__R&R Support