[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpcompta-dev] r4120 - phpcompta/trunk/html/admin/sql/patch
From: |
phpcompta-dev |
Subject: |
[Phpcompta-dev] r4120 - phpcompta/trunk/html/admin/sql/patch |
Date: |
Mon, 23 May 2011 20:09:34 +0200 (CEST) |
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;
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpcompta-dev] r4120 - phpcompta/trunk/html/admin/sql/patch,
phpcompta-dev <=