FIX: SQL INSERT Error Does Not Report Errant Field Name

ID: Q88967

2.00 MS-DOS kbprg kbfixlist kbbuglist

The information in this article applies to:

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, "pno" 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 "pno" 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

Last Reviewed: September 22, 1997