Re: SQL errors on Trial Balance

[Dieter S. <dsi...@sq...>]

The only ORDER BY which doesn't work in 7.1 is the one in a UNION. The
rest work as expected.


Dieter Simader    http://www.sql-ledger.org   (780) 472-8161
DWS Systems Inc.     Accounting Software       Fax: 478-5281
=========== On a clear disk you can seek forever ===========

On Thu, 9 Aug 2001, Federico Sevilla III wrote:

> On Mon, 6 Aug 2001 at 09:33, Dieter Simader wrote:
> > There are a few more of this type of statement in IR, IS and RP.pm
> 
> I noticed. I didn't change any of them, though (except the one that
> generates the trial balance) because I am not confident with the code
> (yet).
> 
> > The code works on PostgreSQL 7.0 Looks like 7.1 is a bit more picky
> > and doesn't like table identifiers. It's logical though, there can
> > only be one column with one name so the table identifier is redundant,
> > BUT, .......
> 
> You lost me. But? What problems do you foresee if we change all "ORDER BY
> chart.accno" to "ORDER BY accno"? I have not run SQL Ledger in a
> production environment yet: we're still evaluating it and will hopefully
> migrate soon. So I am not familiar with the system yet. Not enough to know
> what changes will open pandora's box, and what will open the gates of
> heaven. ;>
> 
>  --> Jijo
> 
> --
> Federico Sevilla III  :: ji...@le...
> Network Administrator :: The Leather Collection, Inc.
> GnuPG Key: <http://www.leathercollection.ph/jijo.gpg>
> 
> 
>