db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From pb2208 <pete.bea...@gmail.com>
Subject Re: Problem with Column Names
Date Mon, 07 Jun 2010 14:08:12 GMT

You bring up an interesting point.  I was thinking about using an import for
the delimted file but ws unsure about the ability to dynamically create a
table from the file.  Is this possible?

As for the Excel files I was going to use POI to read the data.  I don't
know of an import that will import an Excel sheet from an Excel file.  Do
you know of one?



Kristian Waagan-4 wrote:
> 
> On 07.06.10 15:42, Mark Thornton wrote:
>> On 07/06/2010 14:36, Brett Wooldridge wrote:
>>> It is not valid in SQL to have column name (or other identifiers) 
>>> that begin with a numeric character.  You're going to have to code 
>>> specifically for this case.
>>>
>>>
>> Quoted identifiers are (in standard SQL) permitted to be entirely 
>> numeric.
>>
>> create table mytab ("393" decimal(3))
>>
>> should work.
> 
> This statement does work for me (tested on trunk), as does
> 
> ij> create table "999" ("393" decimal(3));
> 
> Are you sure you are quoting the identifier names correctly, both when 
> creating and accessing them?
> Also, are you created the tables/columns manually, or are you trying to 
> use an import procedure?
> 
> 
> Regards,
> -- 
> Kristian
> 
> 
> 

-- 
View this message in context: http://old.nabble.com/Problem-with-Column-Names-tp28805238p28805729.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.


Mime
View raw message