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, test1, test1, 1 2, test2, test2, 2 3, test3, test3, 3 Now i want to "move down" row with id 2, to table looks like this: 1, test1, test1, 1 2, test2, test2, 3 3, test3, test3, 2 Any suggestions ? Maybe there is better way to moving rows ? Regards, Bambero ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------