救急。。。-207 INSERT 的值数目错误

[cqlxy01]

我有两个数据库，两个库中的分别有表torder，表结构完全一样，pb程序的datawindow对其中一个库的表torder做insert时能保存数据，对另一个库的表torder做insert时提示：
Database error code: -207
Database error message: SQLSTATE = 21S01
[Sybase][ODBC Driver][Adaptive Server Anywhere]INSERT 的值数目错误

[smitxx]

要不然复制出来单独执行一下就知道了

[cqlxy01]

我打开sqlspy，显示的sql语句是这样的：INSERT INTO "dba"."torder" ( "areacode", "ordernumber", "orderstatus", "ordertype", "companycode", "personcode", "salesperson", "coordinator", "source", "paymentmode", "grossbill", "discount_rate", "discount_amt", "gst_rate", "totalbill", "create_by", "create_date", "mod_by", "mod_date", "cancel_by", "cancel_date", "domode", "dodate1", "dodate2", "dobyair", "doaddmanual", "dowithice", "dowithsoft", "discount_by", "discount_date", "discount_remarks", "sales_remarks", "customer_remarks", "bankaccount", "allocate_by", "allocate_date", "auditing_info", "auditing_info_date", "auditing_finance", "auditing_finance_date", "cancel_remarks", "newprice", "class", "auditing_flag", "money_flag", "wnl_flag", "logistics_flag", "gathering_by", "depcode", "original_ordernumber", "tc_flag", "invoice" ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )

[smitxx]

显示字段不正确或语法错误了

[fengxiaohan211]

看看字段的个数是否一样 还有顺序

[cqlxy01]

个数一样的,顺序也没问题。

[cqlxy01]

我程序不变，在一个库能执行，另一个库就不行了。