bugPhpCompta - Bugs: bug #17819, Clause FROM ne fonctionne pas

 
 

You are not allowed to post comments on this tracker with your current authentication level.

bug #17819: Clause FROM ne fonctionne pas

Submitter:  dwm <sparkyx>
Submitted:  Thu 21 Sep 2006 09:14:12 PM UTC
   
 
Category:  Blocking Severity:  4 - Important
Item Group:  None Status:  Fixed
Privacy:  Public Assigned to:  sparkyx
Open/Closed:  Closed Release:  release 2.0.6

Tue 26 Sep 2006 10:25:24 AM UTC, comment #1: 

Corrigé dans la version 2.0.7

dwm <sparkyx>
Group administrator
Thu 21 Sep 2006 09:14:12 PM UTC, original submission:  

la clause FROM dans les rapports ne fonctionne pas du tout


> Un autre souci: Dans comptabilité -> Impression -> Rapport, du 1/1/06 au
> 31/12/06 j'ai l'erreur suivante :
>
> Operation cancelled due to error : select sum(deb) as sum_deb, sum(cred)
> as sum_cred from ( select j_poste, case when j_debit='t' then j_montant
> else 0 end as deb, case when j_debit='f' then j_montant else 0 end as
> cred from jrnx join tmp_pcmn on j_poste=pcm_val where j_poste like
> ('700%'::text) and jr_tech_per in (select p_id from parm_periode where
> p_start >= to_date('66','DD.MM.YYYY') and p_end <=
> to_date('78','DD.MM.YYYY')) ) as m

dwm <sparkyx>
Group administrator

 

(Note: upload size limit is set to 16384 kB, after insertion of the required escape characters.)

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

CC list is empty

 

There are 0 votes so far. Votes easily highlight which items people would like to see resolved in priority, independently of the priority of the item set by tracker managers.

 

Follow 2 latest changes.

Date Changed by Updated Field Previous Value => Replaced by
2006-09-26 sparkyx StatusReady For Test Fixed
    Open/ClosedOpen Closed

Back to the top

Powered by Savane 3.13-4b48.
Corresponding source code