Microsoft KB Archive/99089

= RQBE Expression Builder Doesn't Include Path to Table =

Article ID: 99089

Article Last Modified on 12/3/2003

-

APPLIES TO


 * Microsoft Visual FoxPro 3.0 Standard Edition
 * Microsoft FoxPro 2.5b
 * Microsoft FoxPro 2.5a
 * Microsoft FoxPro 2.0
 * Microsoft FoxPro 2.5b for MS-DOS
 * Microsoft FoxPro 2.5a

-



This article was previously published under Q99089



SUMMARY
The Relational Query By Example (RQBE) Expression Builder builds the FROM clause as if the tables existed in the current directory or along the FoxPro path. If you are using a SELECT statement that points to databases that are in a different directory or are not located along the FoxPro path, you must code that statement. You cannot generate it with the RQBE Expression Builder.



MORE INFORMATION
If the table name needs to be prefaced with fully qualified or relative path information, you must code the SELECT statement rather than building it through RQBE.

The following are valid queries:   SELECT * ; FROM X:\\ -or-   SELECT * ; FROM LOCFILE(' ')

Additional query words: VFoxWin FoxDos FoxWin

Keywords: KB99089

-

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

© Microsoft Corporation. All rights reserved.