Microsoft KB Archive/88967

{| = FIX: SQL INSERT Error Does Not Report Errant Field Name =
 * width="100%"|

ID: Q88967

2.00 MS-DOS kbprg kbfixlist kbbuglist

The information in this article applies to:


 * Microsoft FoxPro for MS-DOS, version 2.0

SYMPTOMS
When an incorrect field name is specified in the SQL INSERT command, the error message does not include the name of the incorrect field.

STATUS
Microsoft has confirmed this to be a problem in Microsoft FoxPro version 2.0 for MS-DOS releases dated prior to November 15, 1991. This problem was corrected in the Microsoft FoxPro version 2.0 for MS-DOS release dated November 15, 1991.

MORE INFORMATION
For example, in the following code, &quot;pno&quot; is not the name of a field in the database:

INSERT INTO parts (pno, descript, onhand, onorder,price,cost); VALUES ('B6722','Royal Reindeer',2,6,27.99,20.65) The resulting error message does not report &quot;pno&quot; as the errant field name. Additional reference words: FoxDos buglist2.00 fixlist2.00 INSERT-SQL 2.00 KBCategory: kbprg kbfixlist kbbuglist KBSubcategory: Solution Type : kbfix
 * }