Untitled

mail@pastecode.io avatar
unknown
plain_text
23 days ago
1.4 kB
2
Indexable
Never
rel 47 

Can't Execute this statement:

IF (SELECT COUNT(*) FROM WZ00Inputs_RELUPD(NOLOCK)) = 0
begin
   IF OBJECT_ID('WZ00Inputs_RELUPD', 'U') IS NOT NULL DROP TABLE WZ00Inputs_RELUPD
	RAISERROR('Errore in esecuzione BCP per WZ00Inputs: controllare parametro DIRBCPUP.',16,1)
	ROLLBACK TRAN
end
ELSE
begin
   TRUNCATE TABLE WZ00Inputs
   
   INSERT INTO WZ00Inputs 
   (wziId,      wziNr,      wziCodIns,  wziCodAzi,  
    wziCtl,     wziEnabled, wziVisible, wziRequired,
    wziType,    wziSize,    wziLen,     wziLbl,     
    wziCap,     wziTag,     wziLis,     wziDef,     
    wziHlp,     wziXCtrlsID,wziCryFor,  wziCryCnv,  
    wziNickName)
   SELECT 
    wziId,      wziNr,      wziCodIns,  wziCodAzi,  
    wziCtl,     wziEnabled, wziVisible, wziRequired,
    wziType,    wziSize,    wziLen,     wziLbl,     
    wziCap,     wziTag,     wziLis,     wziDef,     
    wziHlp,     wziXCtrlsID,wziCryFor,  wziCryCnv,  
    wziNickName  
   FROM WZ00Inputs_RELUPD(NOLOCK)
   
   IF OBJECT_ID('WZ00Inputs_RELUPD', 'U') IS NOT NULL DROP TABLE WZ00Inputs_RELUPD
	COMMIT
end


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