日期:2014-05-17  浏览次数:21052 次

insert语句问题
INSERT   INTO   TB_ACC_PAYABLE   (   vcAspID,vcPayableID,vcPayableCode,vcCompanyCode,   vcComfrom,vcPerson,   vcMoneyCode,fRate,vcTaxWay,
vcDeptCode,fPayMoneyW,   fPayMoneyB,fPayTaxB,fPayAllMoneyB,fPayedlMoneyB,   vcTradeWay,vcAccSubjectID,
vcCreator,dCreateDate,   dModifyDate,vcAuditor,dAuditDate,vcStatus,   vcMemo,vcBillType)
VALUES( 'mulaolao ', 'AF0705142302671 ', 'AF0705142302671 ', 'wz106 ', 'BI070372 ', 'admin ', '01 ',1, '内含税 ', '07 ',20,20,0,20,0,
'先付100%预付款,余款在出货后10天内根椐发票付清 ', '应付帐款 ', 'admin ',
TO_DATE( '2007-05-14 ', 'YYYY-MM-DD ') ',
TO_DATE( '2007-05-14 ', 'YYYY-MM-DD '), 'admin ',
TO_DATE( '2007-05-14 ', 'YYYY-MM-DD '), '正式启用 ', ' ', '应付单 ')
执行时提示括号内的字符串没有正确结束,不知道什么意思?

------解决方案--------------------
TO_DATE( '2007-05-14 ', 'YYYY-MM-DD ') ',最后多了个单引号