DOCERR: Syntax Error When Using INSERT INTO Example Code

ID: Q135520

The information in this article applies to:

• Microsoft Visual FoxPro for Windows, version 3.0

SUMMARY

On Page 155 in the Developer's Guide, an INSERT INTO command is given to insert a record into the Customer table of the Tastrade database. When this code is typed into the Command window or in a program, a 'Syntax error' message is displayed. Because an apostrophe is used in the text to be added for the Company field, the Company data needs to be enclosed in double quotation marks.

MORE INFORMATION

This incorrect code:

   INSERT INTO customer (cust_id, company, contact) ;
      VALUES ('SMI007', 'Smith's Delicatessen', 'Sarah Smith')

   INSERT INTO customer (cust_id, company, contact) ;
      VALUES ('SMI007', "Smith's Delicatessen", 'Sarah Smith')