Microsoft KB Archive/138851

= Visual FoxPro for Windows 3.0 creates a free table even if the database is currently open when you use the SELECT-SQL statement with the INTO TABLE clause =

Article ID: 138851

Article Last Modified on 3/17/2005

-

APPLIES TO


 * Microsoft Visual FoxPro 3.0 Standard Edition

-



This article was previously published under Q138851



SYMPTOMS
When using the SELECT-SQL statement with the INTO TABLE  clause to query and place data into a new table, Visual FoxPro will create a new, free table even if a database is currently open.



RESOLUTION
You can keep the table as a free table, or you can append the records from the SELECT-SQL result free table into a database-contained table of the same structure.



STATUS
This behavior is by design. In Visual FoxPro 3.0, there is no automatic way for the SELECT-SQL statement's INTO clause to create a table that is automatically added to a database.

Additional query words: VFoxWin recreate backlink

Keywords: KB138851

-

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

© Microsoft Corporation. All rights reserved.