Re: [stellation-res] Firebird port w/copyright + more patches

["Rodolfo M. Raya" <rmraya@xxxxxxxxxxxxxxx>]

On Mon, 2002-09-02 at 15:29, Rodolfo M. Raya wrote:
 
> Also, here are 5 patches that must be carefully checked. This patches
> modify some queries used to retrieve artifacts.
> 
> Original queries have the form:
> 
>    select s_field1, s_field 2 
>    from s_atable AS table 
>    where s_field1 = "1"
> 
> I deleted the AS keyword because in Firebird/Interbase you can only use
> AS with fields, not table names.
> 
> Now the queries look like this:
> 
>    select s_field1, s_field 2 
>    from s_atable table 
>    where s_field1 = "1"
> 
> I don't know if this will cause troubles with other databases.

I tried with Postgres and there is no problem if we omit the AS keyword
to create an alias for the table name.

Jonathan says MySQL can handle this, so we only need to find out if this
affects Oracle and/or DB2.

Rodolfo

-- 

 MAXPROGRAMS
 IBM Business Partner
 Microsoft MSDN Business Connection Partner
 rmraya@xxxxxxxxxxxxxxx
 http://www.maxprograms.com