Microsoft KB Archive/135520

= DOCERR: Syntax Error When Using INSERT INTO Example Code =

Article ID: 135520

Article Last Modified on 2/15/2000

-

APPLIES TO


 * Microsoft Visual FoxPro 3.0 Standard Edition

-



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

Additional query words: 3.00 VFoxWin

Keywords: KB135520

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.