Microsoft KB Archive/136903

= PRB: Open Dialog Box in SET VIEW If Table Name Contains Space =

Article ID: 136903

Article Last Modified on 10/15/2003

-

APPLIES TO


 * Microsoft Visual FoxPro 3.0b for Macintosh
 * Microsoft FoxPro 2.6a Professional Edition for Macintosh

-



This article was previously published under Q136903



SYMPTOMS
A dialog box appears to prompt the user to 'Select a Table' when the user issues the SET VIEW TO command, or when the user clicks Open on the File menu and opens an existing view file.



CAUSE
When the view file was created, one or more of the tables in the view has a space in the table name.



RESOLUTION
Remove the spaces from the table name. Then recreate the view.



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



Steps to Reproduce Behavior

 * 1) Create one or more tables that has at least one space in its name.
 * 2) In the View window, set a relationship on a common indexed field between this table, either as parent or as a child, and another table.
 * 3) Save the open tables and relations to a view file by:


 * 1) * Clicking Save As on the File menu and entering a name, such as Spaces, in the Save View as dialog box. -or-


 * 1) * Typing CREATE VIEW Spaces in the Command window.
 * 2) Either type SET VIEW TO Spaces in the Command window, or click Open on the File menu, choose View as file type, and open Spaces. At this point, an Open dialog box appears that prompts you to select a table.

Additional query words: vFoxMac FoxMac vue index order

Keywords: KB136903

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.