数据输入问题
新手,子阿数据输入时,用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 ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
请各位高手指教,怎么回事