no
response--however, the problem seems to have gone away in 4.0.14.
-Original Message-
From: [EMAIL PROTECTED]
Subject: RE: Setting variables on update
Date: Mon, 23 Feb 2004 11:50:38 -0700
Try this...works on 4.1.2
UPDATE ControlTable SET NextID=3D 1 + (select @prevval :=3D NextID)
Ed
Matt Fagan wrote:
Hello,
I'm trying to run an SQL update statement like:
UPDATE ControlTable SET @prevval := NextID, NextID = NextID
+ 1
I've tried using a range of different syntax, but nothing
seems to work. This is something that does work in another
SQL server I used to use.
Does anybody
Try this...works on 4.1.2
UPDATE ControlTable SET NextID= 1 + (select @prevval := NextID)
Ed
-Original Message-
From: Sasha Pachev [mailto:[EMAIL PROTECTED]
Sent: Monday, February 23, 2004 11:19 AM
To: Matt Fagan
Cc: [EMAIL PROTECTED]
Subject: Re: Setting variables on update
Matt
Hello,
I'm trying to run an SQL update statement like:
UPDATE ControlTable SET @prevval := NextID, NextID = NextID
+ 1
I've tried using a range of different syntax, but nothing
seems to work. This is something that does work in another
SQL server I used to use.
Does anybody know if this is