<< I have then been using the PROJECT command at the R>prompt in order to make a copy of the table using the ORDER OF parameter (R>PROJECT newtable FROM table USING * ORDER OF primaryindex ASC). >>
If the purpose of this is to obtain a table which will return rows in Primay Key order without having to use an ORDER BY clause, you should be aware that this is NOT SAFE. While R:Base will USUALLY return the rows in the order you want, it doesn't PROMISE to, and this behavior could change at any point in the future without notice. Additionally, there are times even now when R:Base will return data in a different order -- for instance, when the request can be satisfied entirely from an existing index (index only retrieval). -- Larry
