able ("393" Decimal(3))';
>> String cmdSQL = 'Create Table mytable (\"393\" Decimal(3))';
>>
>> These all give me 'Unclosed Character Literal' error.
>>
>
> String cmdSQL = "Create Table mytable (\"393\" Decimal(3))&q
On 07/06/2010 15:18, pb2208 wrote:
Mark,
I read the reference and tried several interations before I asked the
original question. I would really like to get this working.
The following commands have been tried:
String cmdSQL = "Create Table mytable ('393' Decimal(3))";
String cmdSQL = 'Create
expected, but dreaded. I really didn't want to
>> write a
>> lot of special code.
>>
>> Thanks for confirming.
>>
>>
> Fortunately it is also wrong
> The definitive answer is:
>
> http://db.apache.org/derby/docs/10.6/ref/crefsqlj1003454.html
&
e 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.
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) permi
On 07/06/2010 14:48, pb2208 wrote:
That is the answer I expected, but dreaded. I really didn't want to write a
lot of special code.
Thanks for confirming.
Fortunately it is also wrong
The definitive answer is:
http://db.apache.org/derby/docs/10.6/ref/crefsqlj1003454.html
Mark Thornton
going to have to code specifically for
> this case.
>
> Brett
>
>
>
--
View this message in context:
http://old.nabble.com/Problem-with-Column-Names-tp28805238p28805457.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.
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 tab
an I define and reference a column using numeric characters?
>
>
> --
> View this message in context:
> http://old.nabble.com/Problem-with-Column-Names-tp28805238p28805238.html
> Sent from the Apache Derby Users mailing list archive at Nabble.com.
>
>
reference a column using numeric characters?
--
View this message in context:
http://old.nabble.com/Problem-with-Column-Names-tp28805238p28805238.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.
10 matches
Mail list logo
