Re: [sqlite] Column names including spaces

On Wed, Feb 22, 2012 at 11:14 PM, Petite Abeille wrote: > http://www.sqlite.org/lang_keywords.html > @sqlite3 committers: there's a minor error on that page: is says "There are three ways of quoting..." and then goes on to show four ways. -- - stephan beal http://wanderinghorse.net/home/ste

Re: [sqlite] Column names including spaces

On Feb 22, 2012, at 10:21 PM, Pete wrote: > I try to access that column in any way, I get an error, no matter whether I > specify the column name with no quotes, single quotes or double quotes For the record: http://www.sqlite.org/lang_keywords.html

Re: [sqlite] Column names including spaces

>  For example if I "SELECT Col 1 FROM..." I get a "syntax error near 1" > (which I'd expect).  If I try 'SELECT "CoL 1" FROM...", I get and error "no > such column "Col1" - notice there is no space in the column name listed in > the error message". > Are you escaping the quotes for whatever langu

Re: [sqlite] Column names including spaces

On 2/22/2012 4:21 PM, Pete wrote: I seem to have stumbled upon what looks like a bug in SQLite. I accidentally created a column in a table that included a space in its name,eg "Col 1". The CREATE TABLE command accepted without an error but if I try to access that column in any way, I get an err

Re: [sqlite] Column names including spaces

On Wed, Feb 22, 2012 at 10:21 PM, Pete wrote: > I seem to have stumbled upon what looks like a bug in SQLite. I > accidentally created a column in a table that included a space in its > name,eg "Col 1". The CREATE TABLE command accepted without an error but if > I try to access that column in a

[sqlite] Column names including spaces

I seem to have stumbled upon what looks like a bug in SQLite. I accidentally created a column in a table that included a space in its name,eg "Col 1". The CREATE TABLE command accepted without an error but if I try to access that column in any way, I get an error, no matter whether I specify the

Re: [sqlite] Column names in SQL

On Mon, Jun 28, 2010 at 10:07 AM, Serdar Genc wrote: > I have already tried it but not working.. :( > Works for me. punk...@lucknow ~$sqlite3 -- Loading resources from /Users/punkish/.sqliterc SQLite version 3.6.23 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite>

Re: [sqlite] Column names in SQL

I have already tried it but not working.. :( On Mon, Jun 28, 2010 at 6:01 PM, P Kishor wrote: > On Mon, Jun 28, 2010 at 9:58 AM, Serdar Genc > wrote: > > Hi everyone, > > > > I have a problem related to column names . I have a column name as a[b] > in > > my table but > > this creates a problem

Re: [sqlite] Column names in SQL

On Mon, Jun 28, 2010 at 9:58 AM, Serdar Genc wrote: > Hi everyone, > > I have a problem related to column names . I have a column name as a[b] in > my table but > this creates a problem when using SELECT statement as > SELECT a[b] from Table. I know [] is a special character but How would I > tell

[sqlite] Column names in SQL

Hi everyone, I have a problem related to column names . I have a column name as a[b] in my table but this creates a problem when using SELECT statement as SELECT a[b] from Table. I know [] is a special character but How would I tell SQlite that field name is a[b] and I am not using [] with a speci

Re: [sqlite] column names

On 19/05/2009 6:47 PM, Chanas, Olivier wrote: > Hi all, > > I would like to know what are the allowed characters to build a column name. > Is there some limitation ? OTTOMH (because it's not all in one convienient place in the docs): This applies to names of columns, tables, triggers, indexes,

[sqlite] column names

Hi all, I would like to know what are the allowed characters to build a column name. Is there some limitation ? Thanks in advance ? +33 476 14 6656 > olivier.cha...@hp.com ? GMT +1 Hewlett-Packard - 5 av R Chanas, Eybens - 38053 Grenoble Cedex 9 - France __

Re: [sqlite] Column names

I've met the same problem and I'll really appreciate, if this feature starts to work. Maybe I've also missed something in doc. Fanda On Wed, 06 Dec 2006 02:45:30 +0100, Sandeep Suresh <[EMAIL PROTECTED]> wrote: When doing a select with join as : select * from table_1 left join table_2 on

[sqlite] Column names

When doing a select with join as : select * from table_1 left join table_2 on table_1.column11 = table2.column21 column names are *not *qualified with table names. Instead, what I get is column11, column12, column21, column22 and so on. ( where column11, column12 are from table_1 and column2

Re: [sqlite] Column names in a UNION

PROTECTED]> > To: "Sqlite-users" > Sent: Saturday, March 25, 2006 3:45 PM > Subject: [sqlite] Column names in a UNION > > > > Who can tell me what the "correct" column names should be > > for a UNION. For example: > > > > SELECT a, b

Re: [sqlite] Column names in a UNION

sqlite.org Sent: Saturday, March 25, 2006 9:03:27 AM Subject: Re: [sqlite] Column names in a UNION On 3/25/06, Joe Wilson <[EMAIL PROTECTED]> wrote: > Since we're on this topic, what do other databases return for these queries? > > sqlite> select 1 as a, 2 as b UNION ALL

Re: [sqlite] Column names in a UNION

On 3/25/06, Joe Wilson <[EMAIL PROTECTED]> wrote: > Since we're on this topic, what do other databases return for these queries? > > sqlite> select 1 as a, 2 as b UNION ALL select 3 as b, 4 as a; > a|b > 1|2 > 3|4 mysql> select 1 as a, 2 as b UNION ALL select 3 as b, 4 as a; +---+---+ | a |

Re: [sqlite] Column names in a UNION

Since we're on this topic, what do other databases return for these queries? sqlite> select 1 as a, 2 as b UNION ALL select 3 as b, 4 as a; a|b 1|2 3|4 sqlite> select * from (select 1 as a, 2 as b UNION ALL select 3 as b, 4 as a) where b = 3; b|a 3|4 sqlite> select * from (selec

Re: [sqlite] Column names in a UNION

On 3/25/06, Rob Lohman <[EMAIL PROTECTED]> wrote: > Microsoft SQL seems to use the column names from the > first select. So that would be "a, b" in your example. This seems to be the case for current stable versions of Firebird, Postgres and MySQL as well. -- Nemanja Corlija <[EMAIL PROTECTED]>

Re: [sqlite] Column names in a UNION

Microsoft SQL seems to use the column names from the first select. So that would be "a, b" in your example. Rob - Original Message - From: <[EMAIL PROTECTED]> To: "Sqlite-users" Sent: Saturday, March 25, 2006 3:45 PM Subject: [sqlite] Column names in a UNI

[sqlite] Column names in a UNION

Who can tell me what the "correct" column names should be for a UNION. For example: SELECT a, b FROM t1 UNION SELECT x, y FROM t2; The result set of the query above has two columns. Should those columns be named a and b or x and y? Does anybody know what the SQL standard says? Do all the ot

Re: [sqlite] Column Names (revisited)

rking in SQLite 3.x ? I can't seem to get them to work, and can't find anything relating to the latest version on the website. Thanks, Steve -Original Message- From: Drew, Stephen Sent: 06 April 2005 11:57 To: sqlite-users@sqlite.org Subject: [sqlite] Column Names (revisited) Hello,

Re: [sqlite] Column Names (revisited)

Drew, Stephen wrote: Hello, Has anyone else had any problems getting the column names pragmas working in SQLite 3.x ? My experience has been that they don't work as advertised in the documentation in recent versions. However, I don't normally use them, so it hasn't been a problem for me. I su

RE: [sqlite] Column Names (revisited)

5 11:57 To: sqlite-users@sqlite.org Subject: [sqlite] Column Names (revisited) Hello, I've been looking into upgrading to 3.2.1 from 2.8.15 and am still running into problems with returned column names. I've written a piece of code to test four scenarios with 2.8.15 and 3.2.1 and t

[sqlite] Column Names (revisited)

Hello, I've been looking into upgrading to 3.2.1 from 2.8.15 and am still running into problems with returned column names. I've written a piece of code to test four scenarios with 2.8.15 and 3.2.1 and these are the results: Two tables: CREATE TABLE A_TABLE (col1 INTEGER, col2 INTEGER) CREATE

[sqlite] Column Names, Again

Recently, there have been several threads regarding the desired ability to get fully-qualified and original column names from a query result. At the very least, this is useful for dynamic queries and for wrapper writers. There have been at least a couple of proposed solutions, one involving a new

Re: [sqlite] Column names without the callback function

- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

[sqlite] Column names without the callback function

Hi All, I've just started with sqlite, I discovered it a week ago. What I missed was a program to browse the database and open tables in a grid on a form. So I built it myself as a project to learn how to work with sqlite. There is one problem I could not solve and thats an empty recordset. When