Re: [sqlite] Is this expected behavoir, or should I open a ticket?

[Noah Hart]

Never mind, brain glitch.

Sorry for the waste of bandwidth.  Just too late on a Friday afternoon.

Noah

-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Igor Tandetnik
Sent: Friday, February 06, 2009 4:14 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Is this expected behavoir, or should I open a
ticket?

Noah Hart  wrote:
> SQL Version: 3.6.10
>
> CREATE TABLE T1(a, b);
> INSERT INTO T1 VALUES(C1_A, randomblob(1));
>
> SQL error:no such column: C1_A
>
> I know that I can quote the value C1_A, but why is that necessary?

Why do you believe it shouldn't be necessary? C1_A is an identifier, not

a string literal. What is this identifier supposed to name?

Igor Tandetnik 



___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users



CONFIDENTIALITY NOTICE: 
This message may contain confidential and/or privileged information. If you are 
not the addressee or authorized to receive this for the addressee, you must not 
use, copy, disclose, or take any action based on this message or any 
information herein. If you have received this message in error, please advise 
the sender immediately by reply e-mail and delete this message. Thank you for 
your cooperation.


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Is this expected behavoir, or should I open a ticket?

[Igor Tandetnik]

Noah Hart  wrote:
> SQL Version: 3.6.10
>
> CREATE TABLE T1(a, b);
> INSERT INTO T1 VALUES(C1_A, randomblob(1));
>
> SQL error:no such column: C1_A
>
> I know that I can quote the value C1_A, but why is that necessary?

Why do you believe it shouldn't be necessary? C1_A is an identifier, not 
a string literal. What is this identifier supposed to name?

Igor Tandetnik 



___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Is this expected behavoir, or should I open a ticket?

[Noah Hart]

SQL Version: 3.6.10

CREATE TABLE T1(a, b); 
INSERT INTO T1 VALUES(C1_A, randomblob(1));

SQL error:no such column: C1_A

I know that I can quote the value C1_A, but why is that necessary?

Thanks,

Noah







CONFIDENTIALITY NOTICE: 
This message may contain confidential and/or privileged information. If you are 
not the addressee or authorized to receive this for the addressee, you must not 
use, copy, disclose, or take any action based on this message or any 
information herein. If you have received this message in error, please advise 
the sender immediately by reply e-mail and delete this message. Thank you for 
your cooperation.


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users