Untitled

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

Can't Execute this statement:

IF (SELECT COUNT(*) FROM WB00_RELUPD(NOLOCK)) = 0
begin
   IF OBJECT_ID('WB00_RELUPD', 'U') IS NOT NULL DROP TABLE WB00_RELUPD
	RAISERROR('Errore in esecuzione BCP per WB00: controllare parametro DIRBCPUP.',16,1)
	ROLLBACK TRAN
end
ELSE
begin
   TRUNCATE TABLE WB00
   
   INSERT INTO WB00 
   (  GroupId,             TabNumber,           CodIns,              CodAzi,              Enabled,             
      TabCaption,          TableOrViewName,     CustomViewName,      PkFields,            RowStep,             
      SelectSQL,           FromSQL,             WhereSQL,            OrderSQL,            GroupSQL,            
      HavingSQL,           TabLink,             AutoSync,            XHandleGridVorder,   XDisableHeadClick,   
      XHeadClickMode,      XAllowMultiSelection,XAllowWzInput,       XWz00Id,             XAllowEasyInput,     
      XEasyInputId,        XEasyInputColName,   XEasyInputTab,       ActiveTabs,          MasterTab,           
      GridCaption,         GridRowHeight,       GuiDescription,      XMoreResultsMode,    XFormulaGridView,    
      XRekForXSelections,  SelectAllRowsXSel,   CreateXSelections,   XForceRefresh,       XEnableUpdColor,     
      XLockUpdFrames,      XLockUpdHeadClick,   XDocLinkPk)
   SELECT 
      GroupId,             TabNumber,           CodIns,              CodAzi,              Enabled,             
      TabCaption,          TableOrViewName,     CustomViewName,      PkFields,            RowStep,             
      SelectSQL,           FromSQL,             WhereSQL,            OrderSQL,            GroupSQL,            
      HavingSQL,           TabLink,             AutoSync,            XHandleGridVorder,   XDisableHeadClick,   
      XHeadClickMode,      XAllowMultiSelection,XAllowWzInput,       XWz00Id,             XAllowEasyInput,     
      XEasyInputId,        XEasyInputColName,   XEasyInputTab,       ActiveTabs,          MasterTab,           
      GridCaption,         GridRowHeight,       GuiDescription,      XMoreResultsMode,    XFormulaGridView,    
      XRekForXSelections,  SelectAllRowsXSel,   CreateXSelections,   XForceRefresh,       XEnableUpdColor,     
      XLockUpdFrames,      XLockUpdHeadClick,   XDocLinkPk 
   FROM WB00_RELUPD(NOLOCK)
   
   IF OBJECT_ID('WB00_RELUPD', 'U') IS NOT NULL DROP TABLE WB00_RELUPD
	COMMIT
end


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