src/org/openbravo/erpCommon/ad_process/ApplyModules_data.xsql
changeset 5074 bdfd1c945653
parent 4271 bc808429aa25
child 5075 c1b84d47d082
equal deleted inserted replaced
5073:908a09f23ff5 5074:bdfd1c945653
    35            FROM AD_MODULE_INSTALL         
    35            FROM AD_MODULE_INSTALL         
    36           ]]>
    36           ]]>
    37       </Sql>
    37       </Sql>
    38   </SqlMethod>
    38   </SqlMethod>
    39   
    39   
    40   <SqlMethod name="isUpdatingCore" type="preparedStatement" return="boolean">
    40   <SqlMethod name="isUpdatingCoreOrTemplate" type="preparedStatement" return="boolean">
    41       <SqlMethodComment></SqlMethodComment>
    41       <SqlMethodComment></SqlMethodComment>
    42       <Sql><![CDATA[
    42       <Sql><![CDATA[
    43          SELECT count(*) as NAME
    43          SELECT count(*) as NAME FROM
    44            FROM AD_MODULE
    44             ((SELECT 1  
    45           WHERE STATUS='I'      
    45                 FROM AD_MODULE
    46             AND AD_MODULE_ID = '0'
    46                 WHERE STATUS='I'      
       
    47                AND (AD_MODULE_ID = '0' OR TYPE='T'))
       
    48             UNION
       
    49             (SELECT 1
       
    50                 FROM AD_MODULE_INSTALL
       
    51                 WHERE STATUS='I'      
       
    52                AND (AD_MODULE_ID = '0' OR TYPE='T'))) as q
    47           ]]>
    53           ]]>
    48       </Sql>
    54       </Sql>
    49   </SqlMethod>
    55   </SqlMethod>
    50   
    56   
    51   <SqlMethod name="compileCompleteNeeded" type="preparedStatement" return="boolean">
    57   <SqlMethod name="compileCompleteNeeded" type="preparedStatement" return="boolean">