语句报错，非法的零长度标识符

insert into adprice(""CODE"",""GRPCODE"",""SHOPCODE"",""SHOPNAME"",""SPERCODE"",""CHDATE"",""REMARK"",""CSTYLE"",""CSNAME"",""CONCODE"",""SSTYLE"",""STATUS"",""SEENUM"",""SPERNAME"",""ADPRICECLASS"",""BDATE"",""EDATE"") select 'KCJJ'||SheetID,'00044',ShopID,FGETSHOPNM(ShopID),VenderID,CheckDate,Note,'2430','库存进价调整单','3',b.Sstyle,'4',0,'6','2430',CheckDate,CheckDate from UpdCostValue a,bas_supplier b where a.VenderID=b.Suppcode报illegal zero-length identifier
非法的零长度标识符
咋回事儿呢。

解决方案 »

  1.   

    把执行SQL的（""）都删除试试
      

  2.   

    insert into adprice(""CODE"",""GRPCODE"",""SHOPCODE"",""SHOPNAME"",""SPERCODE"",""CHDATE"",""REMARK"",""CSTYLE"",""CSNAME"",""CONCODE"",""SSTYLE"",""STATUS"",""SEENUM"",""SPERNAME"",""ADPRICECLASS"",""BDATE"",""EDATE"") 的双引号全部去掉试试，因为这是表结构！