Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0005447Openbravo ERP09. Financial managementpublic2008-10-07 00:452008-11-25 22:14
cromero 
cromero 
normalminoralways
closedfixed 
5
pi 
2.50 
Core
No
0005447: Accounting server fails in PostgreSQL due a wrong sentence
Due this sentence:
                SELECT (case when ad_table.po_window_id is null then '' else ad_column_identifier('AD_Window',TO_CHAR(ad_table.po_window_id),?) end)||
                  (case when ad_table.po_window_id is null then '' else ' - ' end)|| ad_column_identifier('AD_Window',TO_CHAR(ad_table.ad_window_id),?)

                FROM AD_TABLE
                WHERE AD_TABLE_ID = ?
The accounting server returns an error message.
With this line all works fine:
 ad_column_identifier('AD_Window',TO_CHAR(ad_table.ad_window_id),?) AS DESCRIPTION
No tags attached.
Issue History
2008-10-07 00:45cromeroNew Issue
2008-10-07 00:45cromeroAssigned To => cromero
2008-10-07 00:45cromerosf_bug_id0 => 2150412
2008-10-07 00:45cromeroRegression testing => No
2008-10-07 00:46svnbotCheckin
2008-10-07 00:46svnbotNote Added: 0009407
2008-10-07 00:46svnbotStatusnew => resolved
2008-10-07 00:46svnbotResolutionopen => fixed
2008-10-07 00:46svnbotsvn_revision => 8302
2008-11-25 22:14psarobeStatusresolved => closed

Notes
(0009407)
svnbot   
2008-10-07 00:46   
Repository: openbravo
Revision: 8302
Author: cromeroherrero
Date: 2008-10-07 00:46:50 +0200 (Tue, 07 Oct 2008)

Fixed bug 5447: Accounting server fails in PostgreSQL due a wrong sentence

---
U trunk/src/org/openbravo/erpCommon/ad_background/PeriodicAcctServer_data.xsql
---

https://dev.openbravo.com/websvn/openbravo/?rev=8302&sc=1 [^]