DOCERR: Syntax Error When Using INSERT INTO Example Code (135520)

The information in this article applies to:

Microsoft Visual FoxPro for Windows 3.0

This article was previously published under Q135520

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')

should be:

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

Modification Type:	Major	Last Reviewed:	2/15/2000
Keywords:	KB135520