# Re: Update error ?

Posted by AndyLin on September 30, 1998 at 16:21:30:

In Reply to: Update error ? posted by tang on September 30, 1998 at 12:26:50:

: Sorry ... asp 也在此问 ~
: 我想知这样的写法真有错吗 ??

: Update address SET Ename ='tang',Tel_H ='02-23456789',Tel_O ='',Tel_M ='',BBCall ='',Address_H ='台北市',Address_Now ='同上',Email-1 ='tang525@pcmail.com.tw',Email-2 ='test@hinet.net',Job ='' WHERE Name ='tang'

: ODBC 有设,当查询时无 error 而 Update error 如下

: Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e14'
: [Microsoft][ODBC Microsoft Access 97 驱动程式] UPDATE 陈述式的语法错误。
: Thanks ~
可能是 Email-1 中的 "-" 在 sql 语法中把它当成减号,所以会产生错误,试试看改成 Email_1

Follow Ups:

- Re: Update error ? tang 16:47:21 9/30/98 (0)