Diferencia entre revisiones de «Arreglo Tilde Concursados- RHUN»
De Wiki
(Página nueva: 1) Abrir una conexion a Pampa Central via control center 2) loguearse como Master SELECT count(*) FROM "DH03" where cargo_concursado=0 AND codc_carac='CONC' update "DH03" set cargo_c...) |
|||
| Línea 3: | Línea 3: | ||
SELECT count(*) FROM "DH03" where cargo_concursado=0 AND codc_carac='CONC' | SELECT count(*) FROM "DH03" where cargo_concursado=0 AND codc_carac='CONC' | ||
| + | |||
update "DH03" set cargo_concursado=1 where cargo_concursado=0 AND codc_carac='CONC' | update "DH03" set cargo_concursado=1 where cargo_concursado=0 AND codc_carac='CONC' | ||
Revisión del 11:23 11 jun 2012
1) Abrir una conexion a Pampa Central via control center 2) loguearse como Master
SELECT count(*) FROM "DH03" where cargo_concursado=0 AND codc_carac='CONC'
update "DH03" set cargo_concursado=1 where cargo_concursado=0 AND codc_carac='CONC'
SELECT count(*) FROM "DH03" where cargo_concursado=1 AND codc_carac<>'CONC'
update "DH03" set cargo_concursado=0 where cargo_concursado=1 AND codc_carac<>'CONC'
