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 (138851)



The information in this article applies to:

  • Microsoft Visual FoxPro for Windows 3.0

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.

Modification Type:MajorLast Reviewed:3/17/2005
Keywords:KB138851