[Noalyss-commit] [noalyss] 04/05: Remove debug

[Dany De Bontridder]

sparkyx pushed a commit to branch master
in repository noalyss.

commit 5d3611de0aa807a4ddca895123ee535ddb7097a1
Author: Dany De Bontridder <address@hidden>
Date:   Sat Mar 19 23:49:12 2016 +0100

    Remove debug
---
 include/sql/patch/upgrade123.sql |    6 +-----
 1 files changed, 1 insertions(+), 5 deletions(-)

diff --git a/include/sql/patch/upgrade123.sql b/include/sql/patch/upgrade123.sql
index 49de684..ef58ff8 100644
--- a/include/sql/patch/upgrade123.sql
+++ b/include/sql/patch/upgrade123.sql
@@ -9,25 +9,21 @@ nCount integer;
 sQcode text;
 
 begin
-raise info 'comptaproc.jrnx_ins()';
-
+n_fid := null;
 NEW.j_tech_per := comptaproc.find_periode(to_char(NEW.j_date,'DD.MM.YYYY'));
 if NEW.j_tech_per = -1 then
         raise exception 'Période invalide';
 end if;
 
-raise info 'comptaproc.jrnx_ins : j_qcode is %',NEW.j_qcode;
 if trim(coalesce(NEW.j_qcode,'')) = '' then
         -- how many card has this accounting
         select count(*) into nCount from fiche_detail where ad_id=5 and 
ad_value=NEW.j_poste;
         -- only one card is found , then we change the j_qcode by the card
-raise info 'comptaproc.jrnx_ins : found matching card with accounting 
%',nCount;
         if nCount = 1 then
                 select f_id into n_fid from fiche_detail where ad_id = 5 and 
ad_value=NEW.j_poste;
                 select ad_value into sQcode  from fiche_detail where 
f_id=n_fid and ad_id = 23;
                 NEW.f_id := n_fid;
                 NEW.j_qcode = sQcode;
-                raise info 'comptaproc.jrnx_ins : found card % qcode 
%',n_fid,sQcode;
         end if;
 
 end if;