On Feb 6, 2005, at 1:35 AM, [EMAIL PROTECTED] wrote:
Randall Randall <[EMAIL PROTECTED]> writes:
sqlite> create table package (rowid integer primary key
autoincrement, name
text);
SQL error: near "autoincrement": syntax error
What am I doing wrong, here?
You're putting in the word "autoincrement"
On Feb 6, 2005, at 1:38 AM, Will Leshner wrote:
On Sun, 6 Feb 2005 01:17:45 -0500, Randall Randall
<[EMAIL PROTECTED]> wrote:
Okay, I know there's something obvious I must be
missing:
sqlite> create table package (rowid integer primary key autoincrement,
name text);
SQL error: near "autoincrement":
And your exact SQL command works fine in my 3.1.1 beta version.
-Original Message-
From: Will Leshner [mailto:[EMAIL PROTECTED]
Sent: Saturday, February 05, 2005 10:38 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] autoincrement weirdnesses
On Sun, 6 Feb 2005 01:17:45 -0500, Randa
On Sun, 6 Feb 2005 01:17:45 -0500, Randall Randall
<[EMAIL PROTECTED]> wrote:
>
> Okay, I know there's something obvious I must be
> missing:
>
> sqlite> create table package (rowid integer primary key autoincrement,
> name text);
> SQL error: near "autoincrement": syntax error
>
> What am I doi
Randall Randall <[EMAIL PROTECTED]> writes:
> sqlite> create table package (rowid integer primary key autoincrement, name
> text);
> SQL error: near "autoincrement": syntax error
>
> What am I doing wrong, here?
You're putting in the word "autoincrement". Also, "rowid" is a special word
in SQLit
Okay, I know there's something obvious I must be
missing:
sqlite> create table package (rowid integer primary key autoincrement,
name text);
SQL error: near "autoincrement": syntax error
What am I doing wrong, here?
--
Randall Randall <[EMAIL PROTECTED]>
"2.Do not eat iPod shuffle"
- htt
Within 3.1 changelog, there is mentioned something about using ISO-8601
standards for date and time types:
"CURRENT_TIME, CURRENT_DATE, and CURRENT_TIMESTAMP
These keywords resolve into ISO-8601 time strings. You can use them anywhere
but they are especially useful as the default value for colum
On Wed, 2005-01-26 at 17:45 -0800, Clark Christensen wrote:
> Hello all,
>
> I'm new to SQL, and SQLite, and I find myself needing to
> identify duplicate records in a SQLite table (there are
> about 2K duplicates in a 36K row table). Any suggestions
> or magic SQL queries appreciated :-)
>
On Wed, 2005-01-26 at 17:45 -0800, Clark Christensen wrote:
> Hello all,
>
> I'm new to SQL, and SQLite, and I find myself needing to
> identify duplicate records in a SQLite table (there are
> about 2K duplicates in a 36K row table). Any suggestions
> or magic SQL queries appreciated :-)
>
I've u
Hello sqlite-users,
Is there a way to create a copy of sqlite3_stmt? This is needed to use
precompiled SQL statements in multithreaded environment.
Best regards,
Roman
>Hi,
>
>I'm sorry to hear that you find the components too complicated. They are based
>upon the standard Delphi controls and the functionality was keps as standard as
>possible. They are fatter than a simple wrapper where you have to do all by
>yourself, but that's a choice anyone has to make for
- Forwarded message from albert drent <[EMAIL PROTECTED]> -
Date: Sat, 5 Feb 2005 03:01:20 -0500
From: albert drent <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Subject: Re: [sqlite] [SQLite] Variations in DLLs
To: sqlite-users@sqlite.org
Hi,
I'm sorry to hear that yo
I am currently using a sqlite 2.8 database with an SQLite.NET Provider (from
http://www.eggheadcafe.com/articles/20040714.asp). When I insert data with my
application (which use an connectionString specifying UTF8Encoding=True)
everything goes well. But if I try to insert data with a script usin
13 matches
Mail list logo