You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-user@db.apache.org by Alexandre Gomes <al...@gmail.com> on 2006/05/30 21:27:20 UTC
Column 'XXXX' is not in any table in the FROM list....
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?
thanks
Alê!
Re: Column 'XXXX' is not in any table in the FROM list....
Posted by Alexandre Gomes <al...@gmail.com>.
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 <Be...@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-----
>
>
>
Re: Column 'XXXX' is not in any table in the FROM list....
Posted by "Bernt M. Johnsen" <Be...@Sun.COM>.
>>>>>>>>>>>> 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