KnowledgeBase Archive

An Archive of Early Microsoft KnowledgeBase Articles

View on GitHub

Q259000: PRB: Space in CREATE FROM Field Name Causes Error

Article: Q259000
Product(s): Microsoft FoxPro
Version(s): WINDOWS:3.0,3.0b,5.0,5.0a,6.0
Operating System(s): 
Keyword(s): kbDatabase kbvfp300 kbvfp300b kbvfp500 kbvfp500a kbvfp600 kbXBase KbDBFDBC kbGrpDSFox k
Last Modified: 27-JUL-2000

-------------------------------------------------------------------------------
The information in this article applies to:

- Microsoft Visual FoxPro for Windows, versions 3.0, 3.0b, 5.0, 5.0a, 6.0 
-------------------------------------------------------------------------------

SYMPTOMS
========

If you accidentally add a space to a field name in a table created with the COPY
STRUCTURE EXTENDED command, after creating the table with the CREATE FROM
command, any immediate attempt to access that field (such as with a BROWSE
statement) fails with the following error:

  The data source for this object must be a variable reference.

If the table is in a database, any later attempt will fail with the same error.
If it's a free table, closing the table and re-opening it causes Visual FoxPro
to replace the space in the field name with an underscore.

MORE INFORMATION
================

Steps to Reproduce Behavior
---------------------------

Run the following code in the Command window:

  * Start of Code
  USE HOME() + "labels"

  COPY STRUCTURE EXTENDED TO tableFrom
  USE tableFrom EXCLUSIVE
  ZAP
  INSERT INTO tableFrom ;
      (field_name, field_type, field_len) ;
      VALUES ;
      ("a a", "C", 10)

  CREATE DATABASE dbcTo

  *!* VFP 3 creates the table in the open database.
  *!* CREATE tableTo FROM tableFrom 
  *!* VFP 5 and 6 allow you to specify the database 
  *!* when creating a table.
  CREATE tableTo DATABASE dbcTo FROM tableFrom 

  *!* Note: if you run the VFP 3 code in VFP 5/6 and
  *!* then use the ADD TABLE command, the error you 
  *!* will get on BROWSE is :
  *!* "The fields in table 'c:\temp\tableTo.dbf' 
  *!* did not match the entries in the database."
  SELECT tableTo
  BROWSE
  *End Of Code

REFERENCES
==========

For more information about the CREATE FROM and COPY STRUCTURE EXTENDED commands,
please see the Help files.

Additional query words:

======================================================================
Keywords          : kbDatabase kbvfp300 kbvfp300b kbvfp500 kbvfp500a kbvfp600 kbXBase KbDBFDBC kbGrpDSFox kbDSupport kbCodeSnippet 
Technology        : kbVFPsearch kbAudDeveloper kbVFP300 kbVFP300b kbVFP500 kbVFP600 kbVFP500a
Version           : WINDOWS:3.0,3.0b,5.0,5.0a,6.0
Issue type        : kbprb
Solution Type     : kbnofix

=============================================================================

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.