查詢(xún)收發(fā)存匯總表提示“下標(biāo)越界”
發(fā)布于:2018-02-05 12:21:02
問(wèn)題現(xiàn)象:按照收發(fā)類(lèi)別查詢(xún)收發(fā)存匯總表提示“下標(biāo)越界”
解決方案:在sql的查詢(xún)分析器中執(zhí)行下面語(yǔ)句,將單據(jù)和存貨明細(xì)賬中的出庫(kù)類(lèi)別錯(cuò)誤的設(shè)置為null值,然后查詢(xún)收發(fā)存匯總表就正常了: update ia_subsidiary set crdcode=null where brdflag=0 and crdcode like '1%' update rdrecord set crdcode=null where brdflag=0 and crdcode like '1%'