Re: SQL errors on Trial Balance

[Federico S. I. <ji...@le...>]

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>