当修改数据时,
如果把原来有值的字段的值删除,那么保存的时候提示:
Character,decimal and binary parameters cannot have a precison of zero.
Error in parameter7.
如果加上一个空格,那么就没有问题,怎么解决啊???
...全文
1724打赏收藏
query + updatesql 的问题 ???
当修改数据时, 如果把原来有值的字段的值删除,那么保存的时候提示: Character,decimal and binary parameters cannot have a precison of zero. Error in parameter7. 如果加上一个空格,那么就没有问题,怎么解决啊???
呵呵,从来没有遇见过这种问题。有点好奇,搜索了一下:
The problem does not occur when using CachedUpdates w/TTables
"General SQL error. [INTERSOLV][ODBC Oracle driver]Character, decimal, and binary parameters cannot have a precision of zero. Error in parameter n."
Add a new string value called "Workarounds" to: \HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\MYODBCDSN and set its value to 048576
Currently under investigation.
From /IVODBC/READ.ME (Intersolv 3.0 ODBC readme): "WorkArounds= 048576. Some applications incorrectly specify a precision of 0 for character types when the value will be SQL_NULL_DAT This option overrides the specified precision and sets the precision to 256."