[ANN] Reports, Reports, Reports // Valentina 4.0b7

[Ruslan Zasukhin]

On 11/14/08 4:26 PM, "william humphrey" <shoreagent at gmail.com> wrote:

Hi William,

> I found out that you can't use "as" in the query for the reports.
> 
> This query
> 
> 
> SELECT s_voyages_date as sailed, s_voyages_voyagenumber as voy,
                ^^^^^^^^^^^^^^^^^^^

Here?  

Actually right syntax is
    SELECT expr 'alias_name'

So must be 

 SELECT s_voyages_date 'sailed', s_voyages_voyagenumber 'voy',

http://www.valentina-db.com/dokuwiki/doku.php?id=paradigma:public:en:documen
tation:vsql:reference:reference

SQL Grammar.

I will also check it right now :)


> discharge.s_kcodes_harborname as discharge,
> laden.s_kcodes_harborname as laden
> FROM shadow_voyages
> join shadow_kcodes as discharge on lastport
> join shadow_kcodes as laden on portoflading
> where s_voyages_voyagenumber = 'SS504'
> 
> 
> fails
> 
> 
> while this query
> 
> 
> SELECT s_voyages_date, s_voyages_voyagenumber,
> discharge.s_kcodes_harborname,
> laden.s_kcodes_harborname
> FROM shadow_voyages
> join shadow_kcodes as discharge on lastport
> join shadow_kcodes as laden on portoflading
> where s_voyages_voyagenumber = 'SS504'
> 
> 
> works except that you don't get a distinction between the laden port and the
> discharge port anymore.
> 
> 
> Should I put this in Mantis?  I'm still using reports only on my Intel
> Mac...

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]