Edit C:\Users\Administrator\Desktop\CGI\LIVRAISONS\v1.6.4\03-PROCEDURE_COMPLEMENTAIRE\Galaxie maj contrat produit\0-Script_Update_ENSEIGNES_PLAQUES_LOCATIONS.sql
--4.2 update contratproduit_ set cr_statut = (select refid from refvalues r where refval ='RP' and reftabid = (select tabid from "tables" where tabradical ='Ls_')), cr_etat = (select refid from refvalues r where refval ='FRM' and reftabid = (select tabid from "tables" where tabradical ='Ent')), cr_datefin = '31-12-2024' where cr_produit in (select prdid from product where prdcode in ('LEXSF LE-SE BLEU','LEXSF LE-TD-SE BLEU','LEXSF LE-TD BLEU','LEXSF LE-TE-SE','LEXSF LE-TE BLEU','LEXSF LE BLEU','LFCCLDF','LFCCLDF/LED','LFCCLSF','LFENSDFLE','LFENSDFSH','LFENSINSOLITE','LFENSMAISON','LFENSSAUVDFSC','LFENSSFSC','LFENSSFSH','LFENSSPLE')); --4.4 update contratproduit_ set cr_statut = (select refid from refvalues r where refval ='RP' and reftabid = (select tabid from "tables" where tabradical ='Ls_')), cr_etat = (select refid from refvalues r where refval ='FRM' and reftabid = (select tabid from "tables" where tabradical ='Ent')), cr_datefin = '31-12-2024' where cr_produit in (select prdid from product where prdcode in ('LOCENS16','LOCENS17')); --4.6 update contratproduit_ set cr_statut = (select refid from refvalues r where refval ='RP' and reftabid = (select tabid from "tables" where tabradical ='Ls_')), cr_etat = (select refid from refvalues r where refval ='FRM' and reftabid = (select tabid from "tables" where tabradical ='Ent')), cr_datefin = '31-12-2024' where cr_produit in (select prdid from product where prdcode in ('PLMILL','PLMILLSUPP16','PLMILLSUPP17')); --4.7 update enterprise set entplaquealu_ = 0, entplaquecosseriz_ = 0;
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de