Am 24.10.2007 um 13:14 schrieb Markus Hoenicka:
Quoting nishit sharma <[EMAIL PROTECTED]>:
Hi All,
Sending y peoples same query with some explanation.
i have a database name myds.db which is having one column as index
(integer
default 0) which has no values
in complete database.
when i used to access somthing with reference to index in command
than i get
the error
SQL error: near "index": syntax error
http://sqlite.org/lang_keywords.html
"index" is a reserved word. Just use a different column name which
is not in the above list.
Although "index" is a reserved word, you can try quoting it if you
are not able to change the column name right now:
sqlite> select id, index from test;
SQL error: near "index": syntax error
sqlite> select id, "index" from test;
[should work]
Regards
Michael
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------