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 SYMPTOMSWhen 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: | Major | Last Reviewed: | 3/17/2005 |
---|
Keywords: | KB138851 |
---|
|