|Subject||Re: [Firebird-Java] Wired AS-clause problem|
> Now, I have two problems with this:That's how it was always in Firebird. If you believe that SQL standard says
> 1. IMHO "as" should NOT be optional. Am I wrong on this?
that "AS" is not optinal, please report this as bug (though I doubt that it
will be corrected since it works with "AS" as well ).
> 2. ResultSet.getString("a") gave me "null" instead of "no suchSearch is first done using the alias names, and if nothing if found, then
> column". Why?
real column names are used for the next search, the first match is returned
if something is found.
> BTW: Can someone give me an url of a sql syntax specification?SQL standards are not free, you have to pay for
> Preferably SQL92 or SQL99, not only firebirds docs, which I already
String=SQL). But use FTP search engines, you will definitely find some
"available" for download.