# Re: Update error ?

Posted by tang on September 30, 1998 at 16:47:21:

In Reply to: Re: Update error ? posted by AndyLin on September 30, 1998 at 16:21:30:

: : 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: