Untitled

mail@pastecode.io avatar
unknown
plain_text
5 months ago
2.1 kB
2
Indexable
rel 47 

Can't Execute this statement:

IF (SELECT COUNT(*) FROM WZ00Reports_RELUPD(NOLOCK)) = 0
begin
   IF OBJECT_ID('WZ00Reports_RELUPD', 'U') IS NOT NULL DROP TABLE WZ00Reports_RELUPD
	RAISERROR('Errore in esecuzione BCP per WZ00Reports: controllare parametro DIRBCPUP.',16,1)
	ROLLBACK TRAN
end
ELSE
begin
   TRUNCATE TABLE WZ00Reports
   
   INSERT INTO WZ00Reports 
   (wzrId,                wzrCodIns,            wzrCodAzi,            wzrEnabled,           
    wzrMsl,               wzrHlp,               wzrRPTName,           
    wzrRPTCaption,        wzrNumIss,            wzrPrtFlt,            wzrPrtInc,            
    wzrDatSel,            wzrCreSql,            wzrSql01,             
    wzrSql02,             wzrSbrClaWhr,         wzrFontMode,          wzrTableIdRif,        
    wzrUseSp,             wzrSqlSplitConditions,
    wzrSchedulerTime,     wzrOrientamento,      wzrBeforeExecSql,     wzrBeforeExecSqlMsg,  
    wzrUsaPecAddr,        wzrIdMenu,            wzrSelectionType,     wzrPriority)
   SELECT 
    wzrId,                wzrCodIns,            wzrCodAzi,            wzrEnabled,           
    wzrMsl,               wzrHlp,               wzrRPTName,           
    wzrRPTCaption,        wzrNumIss,            wzrPrtFlt,            wzrPrtInc,            
    wzrDatSel,            wzrCreSql,            wzrSql01,             
    wzrSql02,             wzrSbrClaWhr,         wzrFontMode,          wzrTableIdRif,        
    wzrUseSp,             wzrSqlSplitConditions,
    wzrSchedulerTime,     wzrOrientamento,      wzrBeforeExecSql,     wzrBeforeExecSqlMsg,  
    wzrUsaPecAddr,        wzrIdMenu,            wzrSelectionType,     wzrPriority 
   FROM WZ00Reports_RELUPD(NOLOCK)
   
   IF OBJECT_ID('WZ00Reports_RELUPD', 'U') IS NOT NULL DROP TABLE WZ00Reports_RELUPD
	COMMIT
end


Error Number :
	40002
Error Description :
37000: [Microsoft][ODBC SQL Server Driver][SQL Server]Errore in esecuzione BCP per WZ00Reports: controllare parametro DIRBCPUP.
RDO Errors        :
37000: [Microsoft][ODBC SQL Server Driver][SQL Server]Errore in esecuzione BCP per WZ00Reports: controllare parametro DIRBCPUP.
Leave a Comment