BUG: Query Designer Not Inserting Record if Field Name Has DashLast reviewed: May 30, 1997Article ID: Q165433 |
The information in this article applies to:
SYMPTOMSWhen you try to add a row to an SQL Server table using Query Designer you receive the following error if one of the table's field names contains a "-":
ODBC error: 37000 [Microsoft][SQL Server Driver]Line2: Incorrect syntax near '-' CAUSEThe data tool creates an SQL INSERT statement that doesn't put quotes around field names. The generated INSERT statement would look like:
INSERT INTO "x" (id, e-mail) VALUES (1, 'name')If data tools generated an INSERT statement that used double quotes around the field name, then the INSERT would work. The following syntax would work:
INSERT INTO "x" (id, "e-mail") VALUES (1, 'name')You can verify this by using the SQL Trace utility that ships with SQL Server 6.5. You can use MS Query to test both INSERT statements.
RESOLUTIONYou can workaround this problem in the following ways:
STATUSMicrosoft has confirmed this to be a bug in the Microsoft products listed at the beginning of this article. We are researching this bug and will post new information here in the Microsoft Knowledge Base as it becomes available.
MORE INFORMATION
Steps to Reproduce Behavior
|
Keywords : kbprg vcbuglist500 VCEntIss kbbuglist
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |