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 <table_name> 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