PRB: Empty Cursor Causes Type 1 Error

Last reviewed: May 16, 1996
Article ID: Q124774

The information in this article applies to:

Microsoft FoxPro for Macintosh, version 2.6a

SYMPTOMS

When FoxPro attempts to parse an SQL statement that has a join on an empty cursor, an error type 1 message may be generated. This seems to be both processor and operating system dependent.

NOTE: This behavior does not occur in Visual FoxPro 3.0b for Macintosh.

MORE INFORMATION

The above issue has been seen to occur with processor Floating Point Units. However it does not occur on PowerMac computers or with certain combinations of computer and system software. The issue has occurred on IIci's running system 7.0.1, and Centris 650's running system 7.5. testing has not been done using a software Floating Point Unit.

WORKAROUND

Use Insert Into to put a single record into the cursor.

STATUS

Microsoft is researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Additional reference words: FoxMac 2.60a errmsg err msg message
KBCategory: kb3rdparty kbenv kbprb kbhw kberrmsg
KBSubcategory: FxenvError

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.

Last reviewed: May 16, 1996
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.