db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Alexandre Gomes" <alego...@gmail.com>
Subject Re: Column 'XXXX' is not in any table in the FROM list....
Date Tue, 30 May 2006 21:19:01 GMT
That worked. Thanks.

Now, I'm gonna talk to the NetBeans guys to fix their generated code.

[]s

On 5/30/06, Bernt M. Johnsen <Bernt.Johnsen@sun.com> wrote:
> >>>>>>>>>>>> Alexandre Gomes wrote (2006-05-30 16:27:20):
> > Take a look at this screenshot. The SQL statement is quite simple
> > "select texto from ACORDAO". On the left, you can see ACORDAO table
> > and its 'texto' column. Am I so tired that I cannot see the problem?
>
> try
>
> select "texto" from acordao;
>
> Note that SQL is case insensitive, but identifiers may be quoted.
>
> texto and Texto and TEXTO is the same identifier, while "texto" and
> "Texto" is two other and different identifiers
>
> --
> Bernt Marius Johnsen, Database Technology Group,
> Staff Engineer, Technical Lead Derby/Java DB
> Sun Microsystems, Trondheim, Norway
>
>
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.1 (GNU/Linux)
>
> iD8DBQFEfLK7lFBD9TXBAPARAtbuAKCpx2LgutvsBfiYd8Xmwxbv4bPRrACgwUhf
> 3+x6KttfXGrFY6jwa9P9ZaI=
> =xC7g
> -----END PGP SIGNATURE-----
>
>
>

Mime
View raw message