View Revisions: Issue #1218

Back to Issue
Summary 0001218: +Производство-Заказы-Форма списания возвратного акта- При сохранении Документа созданного из Раскроя-Сформировать возвратный акт
Revision 2018-01-23 18:53 by ruslan
Description Возникает такая ошибка... в тестовой базе не воспроизводиться
Произошла ошибка:
Could not convert variant of type (Null) into type (Integer)

Производство
Application.MainForm: FormWork(TFormWork) XE2 Производство: OLIMP-2015 (ОЛІМП) [Разработчик системы]
ActiveForm: ZakazDtForm(TZakazDtForm) Возвратные Акты
ActiveCustomForm: ZakazDtForm(TZakazDtForm) Возвратные Акты
Qw.SQL.Text = <<
update DGVDT set DAT_ = :dat_, NBR = :nbr, VL1=:VL1, VL2=:VL2,
REALTYP=:RealTyp, PROCNDS = :ProcNds, DCRDNBR=:DCRDNBR,
OUT_DATE=:Out_Date, TYP=:Typ, OrgnInfoID=:OrgnInfoID,
USERNAME=:UserName, MANAGER=:Manager, StorOut=:StorOut, StorMod=:StorMod,
NDSTYP=:NdsTyp, NAMEID=:NAMEID, STORID=:STORID, TRDPID=:TRDPID,
COMMENT=:COMMENT, OPERID=:OPERID, CSDTKTHBID=:CSDTKTHBID,
PODRID=:PODRID, PRSNID=:PRSNID, StorSub = :StorSub, State=:State,
SALEFORM=:SALEFORM, SALECOND=:SALECOND, SUBSCRIBE=:SUBSCRIBE,
RNBR=:RNBR, NNBR=:NNBR, NDATE=:NDATE, DNBR=:DNBR, DDATE=:DDATE,DLASTDATE=:DLASTDATE,
SNAMEID=:SNAMEID, OURACCNID=:OURACCNID, ACCNORGID=:ACCNORGID,
CURRTYP=:CURRTYP, CURS=:CURS,DPRSN=:DPRSN,DDOC=:DDOC, Transfer=:Transfer,
SkidkaTyp = :SkidkaTyp, SkidkaProc = :SkidkaProc, SkidkaSumma = :SkidkaSumma,
CODE=:CODE, EGRNN=:EGRNN, ROUNDNDS=:ROUNDNDS,
TRANSORGNID=:TRANSORGNID, DRIVER_NAME=:DRIVER_NAME,
TRANSDOCNBR=:TRANSDOCNBR, TRANSSUMMA=:TRANSSUMMA, DRDOCNBR=:DRDOCNBR,
VEHICLE_NAME=:VEHICLE_NAME, VEHICLE1_NAME=:VEHICLE1_NAME, VEHICLE2_NAME=:VEHICLE2_NAME,
VEHICLE_NBR=:VEHICLE_NBR, VEHICLE1_NBR=:VEHICLE1_NBR, VEHICLE2_NBR=:VEHICLE2_NBR,
KNNNBR=:KNNNBR, KNNDATE=:KNNDATE, KEGRNN=:KEGRNN, BONUSPROC=:BONUSPROC
where ID=:ID
>>
Revision 2018-01-23 18:54 by ruslan
Description Возникает такая ошибка...при попытке ПЕРЕСОХРАНИТЬ созданный возвратный акт в тестовой базе не воспроизводиться пока
Произошла ошибка:
Could not convert variant of type (Null) into type (Integer)

Производство
Application.MainForm: FormWork(TFormWork) XE2 Производство: OLIMP-2015 (ОЛІМП) [Разработчик системы]
ActiveForm: ZakazDtForm(TZakazDtForm) Возвратные Акты
ActiveCustomForm: ZakazDtForm(TZakazDtForm) Возвратные Акты
Qw.SQL.Text = <<
update DGVDT set DAT_ = :dat_, NBR = :nbr, VL1=:VL1, VL2=:VL2,
REALTYP=:RealTyp, PROCNDS = :ProcNds, DCRDNBR=:DCRDNBR,
OUT_DATE=:Out_Date, TYP=:Typ, OrgnInfoID=:OrgnInfoID,
USERNAME=:UserName, MANAGER=:Manager, StorOut=:StorOut, StorMod=:StorMod,
NDSTYP=:NdsTyp, NAMEID=:NAMEID, STORID=:STORID, TRDPID=:TRDPID,
COMMENT=:COMMENT, OPERID=:OPERID, CSDTKTHBID=:CSDTKTHBID,
PODRID=:PODRID, PRSNID=:PRSNID, StorSub = :StorSub, State=:State,
SALEFORM=:SALEFORM, SALECOND=:SALECOND, SUBSCRIBE=:SUBSCRIBE,
RNBR=:RNBR, NNBR=:NNBR, NDATE=:NDATE, DNBR=:DNBR, DDATE=:DDATE,DLASTDATE=:DLASTDATE,
SNAMEID=:SNAMEID, OURACCNID=:OURACCNID, ACCNORGID=:ACCNORGID,
CURRTYP=:CURRTYP, CURS=:CURS,DPRSN=:DPRSN,DDOC=:DDOC, Transfer=:Transfer,
SkidkaTyp = :SkidkaTyp, SkidkaProc = :SkidkaProc, SkidkaSumma = :SkidkaSumma,
CODE=:CODE, EGRNN=:EGRNN, ROUNDNDS=:ROUNDNDS,
TRANSORGNID=:TRANSORGNID, DRIVER_NAME=:DRIVER_NAME,
TRANSDOCNBR=:TRANSDOCNBR, TRANSSUMMA=:TRANSSUMMA, DRDOCNBR=:DRDOCNBR,
VEHICLE_NAME=:VEHICLE_NAME, VEHICLE1_NAME=:VEHICLE1_NAME, VEHICLE2_NAME=:VEHICLE2_NAME,
VEHICLE_NBR=:VEHICLE_NBR, VEHICLE1_NBR=:VEHICLE1_NBR, VEHICLE2_NBR=:VEHICLE2_NBR,
KNNNBR=:KNNNBR, KNNDATE=:KNNDATE, KEGRNN=:KEGRNN, BONUSPROC=:BONUSPROC
where ID=:ID
>>