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

Submitted by:  Dany De Bontridder <sparkyx>
Submitted on:  Thu 21 Sep 2006 09:14:12 PM UTC  
 
Category: BlockingSeverity: 4 - Important
Item Group: NoneStatus: Fixed
Privacy: PublicAssigned to: Dany De Bontridder <sparkyx>
Open/Closed: ClosedRelease: release 2.0.6

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

Corrigé dans la version 2.0.7

Dany De Bontridder <sparkyx>
Project AdministratorIn charge of this item.
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

Dany De Bontridder <sparkyx>
Project AdministratorIn charge of this item.

 

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

CC list is empty

 

Do you think this task is very important?
If so, you can click here to add your encouragement to it.
This task has 0 encouragements so far.

Only logged-in users can vote.

 

Please enter the title of George Orwell's famous dystopian book (it's a date):

 

 

Follow 2 latest changes.

Date Changed By Updated Field Previous Value => Replaced By
Tue 26 Sep 2006 10:25:24 AM UTCsparkyxStatusReady For Test=>Fixed
  Open/ClosedOpen=>Closed

Back to the top


Powered by Savane 3.1-cleanup1