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 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 ?
First of all, is that what you really want? Just the last column moved?
Or do you want:
1, test1, test1, 1
2, test3, test3, 3
3, test2, test2, 2
This seems to be what your words are describing.
And, if so, would:
1, test1, test1, 1
3, test3, test3, 3
4, test2, test2, 2
be okay? That would seem simpler to implement.
HTH,
Gerry
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------