固定资产月结报错: BOF或EOF有一个是真
问题:
固定资产月结报错:
如下图:
处理方式
if not exists(select 1 from Accinformation where cSysID='FA' and cName=N'bFAPrintRFID')
insert into accinformation([cSysID], [cID], [cName], [cCaption], [cType], [cValue], [cDefault], [bVisible], [bEnable])
values('FA',206,'bFAPrintRFID','RFID打印卡片编号写入芯片','bBoolean','False','False',0,0)
go
if not exists(select 1 from Accinformation where cSysID='FA' and cName=N'sFARFIDPrinterStd')
insert into accinformation([cSysID], [cID], [cName], [cCaption], [cType], [cValue], [cDefault], [bVisible], [bEnable])
values('FA',207,'sFARFIDPrinterStd','RFID打印机型号','sString','','',0,0)
go
if not exists(select 1 from Accinformation where cSysID='FA' and cName=N'sFARFIDPrintPort')
insert into accinformation([cSysID], [cID], [cName], [cCaption], [cType], [cValue], [cDefault], [bVisible], [bEnable])
values('FA',208,'sFARFIDPrintPort','RFID打印机端口名','sString','','',0,0)