Hi Bill,
You need to use double-quotes rather than single-quotes. See the
following section in the Derby Reference Guide:
http://db.apache.org/derby/docs/10.5/ref/ref-single.html#crefsqlj34834
Hope this helps,
-Rick
Wildman wrote:
Thanks, Rick -- that is indeed quite helpful.
I am a bit unsure of how to specify the table name so that it retains
lower-case. If I quote the name when creating the table; e.g. "create table
'part_type' ( .... )" then I get a SQL error complaining about the quotes.
Is there another way to specify a table name including casing?
Thanks!
-Bill
