My guess is that it will be hard to do in one statement, but I still don't understand what you're trying to do. Show us through sql how you do it in two steps or explain your problem in a way easier to understand, then we may be able to give a better answer.

Set

-----Original Message-----
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of isaac_cm
Sent: 4. september 2009 12:49
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Re: update previous and current record in one update statement

I want to exchange value of specific record and the one precede it , I can do that using two update sql of course but I just wonder if it can be done in one sql.

Thanks