Author: danydb Date: 2011-05-23 20:09:33 +0200 (Mon, 23 May 2011) New Revision: 4120
Modified: phpcompta/trunk/html/admin/sql/patch/upgrade93.sql Log: 0000269: Pas de synchronisation entre date ANC et ACC Modified: phpcompta/trunk/html/admin/sql/patch/upgrade93.sql =================================================================== --- phpcompta/trunk/html/admin/sql/patch/upgrade93.sql 2011-05-23 18:06:18 UTC (rev 4119) +++ phpcompta/trunk/html/admin/sql/patch/upgrade93.sql 2011-05-23 18:09:33 UTC (rev 4120) @@ -62,6 +62,7 @@ create type anc_table_account_type as (po_id bigint,pa_id bigint,PO_NAME TEXT,po_description text,sum_amount numeric(25,4),card_account text,name text); + create or replace function comptaproc.table_analytic_account (p_from text,p_to text) returns setof anc_table_account_type as @@ -114,6 +115,12 @@ end; $BODY$ language plpgsql; +update operation_analytique set oa_date=j_date + from jrnx + where operation_analytique.j_id=jrnx.j_id + and operation_analytique.j_id in (select j_id + from jrnx join jrn on (j_grpt=jr_grpt_id) + ); update version set val=94; commit; _______________________________________________ Phpcompta-dev mailing list [email protected] https://lists.nongnu.org/mailman/listinfo/phpcompta-dev
