1,079
社区成员
发帖
与我相关
我的任务
分享数据输入问题
新手，子阿数据输入时，用insert row 进行数据插入
但是再插入数据有一colmun 即 bookid 数据类型设为dec（5，0）但是在输入一个大于6位的数据数据是总是出现 如下提示
SQLSTATE = 07006
[Sybase][ODBC Driver][Adaptive Server Anywhere]Restricted data type attribute violation: Cannot convert 12000001 to a decimal(5,0)
No changes made to database.
INSERT INTO "bookinfo" ( "bookid", "bookname", "isbn", "title", "publishdate", "author", "words", "publisherid", "number", "keywords", "abstract", "price" ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
请各位高手指教，怎么回事
但是再插入数据有一colmun 即 bookid 数据类型设为dec（5，0）但是在输入一个大于6位的数据数据是总是出现 如下提示
SQLSTATE = 07006
[Sybase][ODBC Driver][Adaptive Server Anywhere]Restricted data type attribute violation: Cannot convert 12000001 to a decimal(5,0)
No changes made to database.
INSERT INTO "bookinfo" ( "bookid", "bookname", "isbn", "title", "publishdate", "author", "words", "publisherid", "number", "keywords", "abstract", "price" ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
请各位高手指教，怎么回事
...全文
请发表友善的回复…
发表回复
workhand 2003-09-29
- 打赏
- 举报
最好设置掩码
xiluoshen2000 2003-09-29
- 打赏
- 举报
定义的位数太少了
zhangdatou 2003-09-29
- 打赏
- 举报
同意楼上
klbt 2003-09-29
- 打赏
- 举报
把你的定义拓宽一些，dec（6，0）
