DOCERR: Syntax Error When Using INSERT INTO Example Code

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.

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