PRB: SQL Cursor Name with Blanks Causes "Invalid Name"

Last reviewed: May 29, 1996
Article ID: Q112776

The information in this article applies to:

Microsoft FoxPro for Macintosh, version 2.5b

SYMPTOMS

Sending output from the RQBE window to a cursor whose name contains a blank causes the following error message:

   Invalid name

CAUSE

Cursors are alias names, which cannot contain blanks.

STATUS

This behavior is by design.

MORE INFORMATION

Although Macintosh files can contain blanks, aliases cannot.

An alias can consist of up to 10 letters, digits, or underscores and it must begin with a letter or an underscore.

Steps to Reproduce Behavior

Assuming FoxPro is installed in a folder (directory) named "FoxPro/Mac" and the volume (drive) name is "Macintosh HD", type the following command in the Command window:
```
      USE "Macintosh HD:\FoxPro/Mac\Tutorial\Customer"
```
From the Run menu, choose New Query.
In the Output list box, select Cursor.
In the Name text box, type "My Query" (without the quotation marks).
Choose Do Query.

REFERENCES

"Language Reference," version 2.5, page 19

Additional reference words: FoxMac 2.50b errmsg err msg structured query
language spaces
KBCategory: kbprg kberrmsg kbprb
KBSubcategory:

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 29, 1996
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.