Project

General

Profile

Download (630 Bytes)

Hot_fix đính kèm file.txt

Luc Tran Van, 11/11/2022 02:19 PM

 
1 
------SELECT RA SAU ĐÓ LẤY TỪNG CÁI tR_REQUEST_DOC_FILE_ID LẮP VÀO REF_ID BÊN DƯỚI-----
2 
SELECT * FROM TR_REQUEST_DOC_FILE trdf WHERE trdf.REQ_ID = 'TRRD00000257359'
3 

    		
  

  

    
      4
    
    
      
------SELECT RA SAU ĐÓ LẤY TỪNG CÁI attacH_ID LẮP VÀO ATTACH_ID BÊN DƯỚI-----


    		
  

  

    
      5
    
    
      
SELECT * FROM CM_ATTACH_FILE WHERE REF_MASTER = 'TRRD00000257359'


    		
  

  

    
      6
    
    
      

    		
  

  

    
      7
    
    
      
UPDATE CM_ATTACH_FILE SET REF_ID = '' WHERE ATTACH_ID = '' AND REF_MASTER = 'TRRD00000257359'


    		
  

  

    
      8
    
    
      
UPDATE CM_ATTACH_FILE SET REF_ID = '' WHERE ATTACH_ID = '' AND REF_MASTER = 'TRRD00000257359'


    		
  

  

    
      9
    
    
      
UPDATE CM_ATTACH_FILE SET REF_ID = '' WHERE ATTACH_ID = '' AND REF_MASTER = 'TRRD00000257359'