Microsoft KB Archive/100464

PRA: Ordered Query on Attached Paradox Table

Article ID: Q100464
Creation Date: 22-JUN-1993
Revision Date: 19-SEP-1996 The information in this article applies to:

Microsoft Access version 1.0

SYMPTOMS

An ordered query (a query in which one or more fields are sorted using the SQL ORDER BY clause) on an attached Paradox table with secondary indexes does not consistently select all the records that meet the designated criteria.

RESOLUTION

In Microsoft Access version 1.0, run the query as a make-table query, without specifying a sort on secondary indexed fields. Then, create and run an ordered select query on the new table.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Access version 1.0. This problem no longer occurs in Microsoft Access version 1.1.

MORE INFORMATION

This problem occurs only when the query is ordered by a secondary index field.

A Paradox secondary index is a field, other than the primary key, that is indexed. This is analogous to Microsoft Access tables that are indexed on fields other than the primary key.

How to Check for Secondary Indexes

Attach a Paradox table in Microsoft Access.
Select the attached table in the Database window and choose Design. An error message will appear, stating that some properties cannot be modified.
Choose Yes to open the table.
Select each row in the table and note its indexed property. The indexed property for secondary indexes is Yes.

How to Verify That Your Query Results Are Consistent

Check for secondary indexes. If you find any secondary indexes, complete the following steps.
Open the query in Design view.
Remove all sort specifications based on secondary indexes.
Run the query and note the number of rows returned.
Enter the sort specifications for the secondary index fields.
Rerun the query.

If the number of rows returned from steps 4 and 6 are not the same, the query is not returning correct results. Paradox is manufactured by Borland International, Inc., a vendor independent of Microsoft; we make no warranty, implied or otherwise, regarding this product's performance or reliability.

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Additional reference words: 1.00
KBCategory: kb3rdparty
KBSubcategory: IsmPdox