一个很弱的问题adoquery,呵呵
调试时sql执行没问题,但执行到Query1.ExecSQL时出错,报oracle的错误:00933,sql未正确结束。大家帮忙看看吧!
sqlstr:='INSERT INTO PLANT_PRODUCTION select '''+nextyear+''','''+nextmonth+
''', DEPT_CODE , ITEM_CODE, ITEM_NAME,'+
'UNIT, MONTH_PLAN, QUARTER_PLAN, YEAR_PLAN, MONTH_VALUE,'+
''''','''', REMARK, SORT_NO '+
'from PLANT_PRODUCTION where tab_year='''+year+''' and tab_month='''+ month+'''' ;
Query1.Close;
Query1.Connection:=ADOConnection1;
Query1.SQL.Clear;
Query1.SQL.add(sqlstr);
Query1.ExecSQL;