Microsoft KB Archive/97006

{|
 * width="100%"|

PRA: Bad Results Searching Multiple-Column Paradox Indexes
'Article ID: Q97006

Creation Date: 04-APR-1993

Revision Date: 19-SEP-1996' The information in this article applies to:


 * Microsoft Access version 1.0

SYMPTOMS

Using the Find command on the Edit menu to search Paradox fields for specific values does not work properly if all of the following are true:


 * The field being searched is part of a multicolumn index.
 * The field contains NULLs.
 * The Search Fields As Formatted option is disabled in the Find In Field dialog box on the Edit menu.

RESOLUTION

To work around this problem, select the Search Fields As Formatted option in the Find In Field dialog box so that the index is not used in the search. Similarly, when querying on Paradox fields that are part of a multicolumn index containing NULL values, use the LIKE operator in places where you would normally use the equivalence operator. For example, avoid using

SELECT * FROM TestTable WHERE ((FieldX=23)); and instead use the following: SELECT * FROM TestTable WHERE ((FieldX Like 23)); 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.
 * }

-

"THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED &quot;AS IS&quot; 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." '' ©1997 Microsoft Corporation. All rights reserved. Legal Notices.

''

Additional reference words: 1.00

KBCategory: kb3rdparty

KBSubcategory: IsmPdox