Re: [sqlite] Changing order - why??

2006-11-12 Thread Ralph Wetzel
Hi folks, might it be possible, that someone explains, why anyone would put effort in this task? Aren't databases designed to keep data in whatever order... :-? Greetings, Ralph Hello I have little problem with changing order of rows. I have a simple table articles: CREATE TABLE articles

Re: [sqlite] Changing order

2006-11-12 Thread Robert Zajda
On 11/12/06, Gerry Snyder <[EMAIL PROTECTED]> wrote: Bambero wrote: > Hello > > I have little problem with changing order of rows. I have a simple > table articles: > > CREATE TABLE articles ( > id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, > title VARCHAR, > content VARCHAR, > order INTEGER

Re: [sqlite] Changing order

2006-11-12 Thread Gerry Snyder
Bambero wrote: Hello I have little problem with changing order of rows. I have a simple table articles: CREATE TABLE articles ( id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, title VARCHAR, content VARCHAR, order INTEGER UNIQUE, ); when inserting row order is a copy of id (trigger used). I

[sqlite] Changing order

2006-11-12 Thread Bambero
Hello I have little problem with changing order of rows. I have a simple table articles: CREATE TABLE articles ( id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, title VARCHAR, content VARCHAR, order INTEGER UNIQUE, ); when inserting row order is a copy of id (trigger used). I have few rows 1,